eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.XLA_UPGRADE_PUB dependencies on GL_LEDGER_RELATIONSHIPS

Line 1062: FROM gl_ledger_relationships glr

1058: AND gps.application_id IN (275,8721)
1059: AND gps.ledger_id IN (SELECT l.ledger_id
1060: FROM gl_ledgers l
1061: WHERE l.ledger_id IN (SELECT DISTINCT target_ledger_id
1062: FROM gl_ledger_relationships glr
1063: WHERE glr.primary_ledger_id = i_ledger_id
1064: AND glr.application_id = 101
1065: AND ((glr.target_ledger_category_code IN ('SECONDARY','ALC')
1066: AND glr.relationship_type_code = 'SUBLEDGER')

Line 1084: FROM gl_ledger_relationships glr

1080: AND gps.application_id = i_application_id
1081: AND gps.ledger_id IN (SELECT l.ledger_id
1082: FROM gl_ledgers l
1083: WHERE l.ledger_id IN (SELECT DISTINCT target_ledger_id
1084: FROM gl_ledger_relationships glr
1085: WHERE glr.primary_ledger_id = i_ledger_id
1086: AND glr.application_id = 101
1087: AND ((glr.target_ledger_category_code IN ('SECONDARY','ALC')
1088: AND glr.relationship_type_code = 'SUBLEDGER')

Line 1229: FROM gl_ledger_relationships glr

1225:
1226: -- Retreive the List of Primary and ALC Ledgers for Upgrade
1227: SELECT target_ledger_id
1228: BULK COLLECT INTO g_array_ledger_id
1229: FROM gl_ledger_relationships glr
1230: WHERE glr.application_id = 101
1231: AND glr.primary_ledger_id = p_ledger_id
1232: AND ((glr.target_ledger_category_code IN ('SECONDARY','ALC')
1233: AND glr.relationship_type_code = 'SUBLEDGER')

Line 1286: FROM gl_ledger_relationships glr

1282: AND gps.application_id IN (275, 8721)
1283: AND gps.ledger_id IN ( SELECT l.ledger_id
1284: FROM gl_ledgers l
1285: WHERE l.ledger_id IN (SELECT DISTINCT glr.target_ledger_id
1286: FROM gl_ledger_relationships glr
1287: WHERE glr.primary_ledger_id = p_ledger_id
1288: AND glr.application_id = 101
1289: AND (( glr.target_ledger_category_code IN ('SECONDARY' , 'ALC')
1290: AND glr.relationship_type_code = 'SUBLEDGER' )

Line 1347: FROM gl_ledger_relationships glr

1343: AND gps.application_id = l_application_id
1344: AND gps.ledger_id IN (SELECT l.ledger_id
1345: FROM gl_ledgers l
1346: WHERE l.ledger_id IN (SELECT DISTINCT glr.target_ledger_id
1347: FROM gl_ledger_relationships glr
1348: WHERE glr.primary_ledger_id = p_ledger_id
1349: AND glr.application_id = 101
1350: AND ((glr.target_ledger_category_code IN ('SECONDARY','ALC')
1351: AND glr.relationship_type_code = 'SUBLEDGER')