Tuesday, 24 April 2012

xml template query

select * from XDO_DS_DEFINITIONS_B where data_source_code = 'MASNSPMVEN'

select * from XDO_DS_DEFINITIONS_TL where data_source_code = 'MASNSPMVEN' --rownum < 3

select * from XDO_TEMPLATES_B where TEMPLATE_CODE like '%MASCGPRECEIPTRPT%'--'Template Short code'

select * from XDO_TEMPLATES_TL where TEMPLATE_CODE = 'MASCGPRECEIPTRPT'--'Template Short code'

select * from XDO_TEMPLATES_VL where TEMPLATE_CODE like 'MASCGPRECEIPTRPT%'

select * from XDO_LOBS where lob_code like 'MASCGPRECEIPTRPT%'-- 'Template Short code'

4 comments:

  1. I found your blog very interesting. Thanks for sharing your comment,
    Oracle fusion hcm training

    ReplyDelete
  2. oracle fusion financials online training at erptree.com is worlds best online training center. we have excelled in knowledge sharing through online. we have almost all country students as our subscribers for online course. 10+ years of experience we have in handling various ascent people.
    we have user friendly website where you will be provided with all the required details and
    Self-paced DEMO videos

    ReplyDelete
  3. Thanks for sharing your experience and very good points were stated in the blog for further information visit
    CALFRE

    ReplyDelete
  4. CALFRE handles oracle fusion financials online training and its modules maintaining classroom based training with the self-paced videos. An expert having ten plus years of self-experience handles the training period through online and explains each and every point perfectly. We recently launched our institute in the USA and getting the best reputation over there



    Oracle fusion Financials Training in hyderabad

    Oracle Fusion Financials online Training in hyderabad

    ReplyDelete