1. Link Between Legal Entity & Ledger along with Default Company Assigned in Legal Entity
SELECT flex_segment_value
,gll.*
FROM gl_legal_entities_bsvs gleb
,gl_ledger_le_v gll
WHERE gleb.legal_entity_id = gll.legal_entity_id
AND ledger_category_code = 'PRIMARY'
AND gleb.flex_segment_value = :p_company
or
2. Default Company value assigned in Legal Entity
SELECT * FROM XLE_ENTITY_PROFILES
SELECT flex_segment_value
,gll.*
FROM gl_legal_entities_bsvs gleb
,gl_ledger_le_v gll
WHERE gleb.legal_entity_id = gll.legal_entity_id
AND ledger_category_code = 'PRIMARY'
AND gleb.flex_segment_value = :p_company
or
2. Default Company value assigned in Legal Entity
SELECT * FROM XLE_ENTITY_PROFILES
No comments:
Post a Comment