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'
Posted by at
Labels:

4 comments:

  1. oraclehcm3 March 2017 at 17:31

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

    ReplyDelete
  2. ERP6 March 2017 at 12:05

    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. oraclefusion7 March 2017 at 09:41

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

    ReplyDelete
  4. Unknown28 April 2017 at 11:51

    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

Subscribe to: Post Comments (Atom)