DBA Data[Home] [Help]

APPS.GL_MC_INFO dependencies on GL_SECONDARY_LEDGER_RSHIPS_V

Line 671: SELECT 'Enabled RS exists' FROM GL_SECONDARY_LEDGER_RSHIPS_V rs

667: UPDATE GL_LEDGER_LE_BSV_GT gt
668: SET gt.RELATIONSHIP_ENABLED_FLAG = 'Y'
669: WHERE (gt.LEDGER_CATEGORY_CODE = 'SECONDARY'
670: AND EXISTS (
671: SELECT 'Enabled RS exists' FROM GL_SECONDARY_LEDGER_RSHIPS_V rs
672: WHERE rs.ledger_id = gt.ledger_id
673: AND rs.relationship_enabled_flag = 'Y'))
674: OR (gt.LEDGER_CATEGORY_CODE = 'ALC'
675: AND EXISTS (