Thursday, 19 September 2013

Table for LEGAL ENTITY details in Oracle Apps R12

 
select * from XLE_ENTITY_PROFILES

SELECT xep.legal_entity_id, xep.party_id,
xep.legal_entity_identifier,xep.NAME,hp.party_name
FROM xle_entity_profiles xep,hz_parties hp
WHERE xep.party_id = hp.party_id

3 comments:

  1. Thanks for sharing your thoughts about pools and spas
    chutes and ladders. Regards

    Also visit my web-site best online pool supply reviews ()

    ReplyDelete
  2. Hi, Could you also extend this query by adding the logic to fetch OU in this query ?

    ReplyDelete