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.

APPS.GL_FLATTEN_ACCESS_SETS dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 816: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,

812: (SELECT 1
813: FROM GL_ACCESS_SET_NORM_ASSIGN glasna
814: WHERE glasna.ledger_id IN
815: (SELECT distinct gllsa.ledger_set_id
816: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
817: GL_LEDGERS gll
818: WHERE gllsa.status_code IN ('I', 'D')
819: AND gll.ledger_id = gllsa.ledger_set_id
820: AND gll.chart_of_accounts_id =

Line 962: GL_LEDGER_SET_ASSIGNMENTS gllsa

958: glasna.start_date, glasna.end_date
959: FROM GL_SEG_VAL_HIERARCHIES glsvh,
960: GL_ACCESS_SETS glas,
961: GL_ACCESS_SET_NORM_ASSIGN glasna,
962: GL_LEDGER_SET_ASSIGNMENTS gllsa
963: WHERE glsvh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
964: AND glsvh.status_code in ('I', 'D')
965: AND glas.security_segment_code <> 'F'
966: AND glas.secured_seg_value_set_id =

Line 1030: GL_LEDGER_SET_ASSIGNMENTS gllsa

1026: glasna.start_date, glasna.end_date
1027: FROM GL_SEG_VAL_HIERARCHIES glsvh,
1028: GL_ACCESS_SETS glas,
1029: GL_ACCESS_SET_NORM_ASSIGN glasna,
1030: GL_LEDGER_SET_ASSIGNMENTS gllsa
1031: WHERE glsvh.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
1032: AND glsvh.parent_flex_value = 'T'
1033: AND glsvh.status_code = 'I'
1034: AND glas.secured_seg_value_set_id =

Line 1142: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,

1138: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1139: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1140: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1141: glasna.start_date, glasna.end_date
1142: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1143: GL_LEDGERS gll,
1144: GL_ACCESS_SET_NORM_ASSIGN glasna,
1145: GL_ACCESS_SETS glas
1146: WHERE gllsa.status_code IN ('I', 'D')

Line 1191: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,

1187: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1188: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1189: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1190: glasna.start_date, glasna.end_date
1191: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1192: GL_LEDGERS gll,
1193: GL_ACCESS_SET_NORM_ASSIGN glasna,
1194: GL_ACCESS_SETS glas,
1195: GL_SEG_VAL_HIERARCHIES glsvh

Line 1243: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,

1239: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1240: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1241: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1242: glasna.start_date, glasna.end_date
1243: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1244: GL_LEDGERS gll,
1245: GL_ACCESS_SET_NORM_ASSIGN glasna,
1246: GL_ACCESS_SETS glas,
1247: GL_SEG_VAL_HIERARCHIES glsvh

Line 1296: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,

1292: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1293: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1294: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1295: glasna.start_date, glasna.end_date
1296: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa,
1297: GL_LEDGERS gll,
1298: GL_ACCESS_SET_NORM_ASSIGN glasna
1299: WHERE gllsa.status_code IN ('I', 'D')
1300: AND gll.ledger_id = gllsa.ledger_set_id

Line 1357: GL_LEDGER_SET_ASSIGNMENTS gllsa

1353: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1354: glasna.start_date, glasna.end_date
1355: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1356: GL_ACCESS_SETS glas,
1357: GL_LEDGER_SET_ASSIGNMENTS gllsa
1358: WHERE glasna.status_code IN ('I', 'D')
1359: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1360: AND glas.access_set_id = glasna.access_set_id
1361: AND glas.chart_of_accounts_id =

Line 1411: GL_LEDGER_SET_ASSIGNMENTS gllsa,

1407: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1408: glasna.start_date, glasna.end_date
1409: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1410: GL_ACCESS_SETS glas,
1411: GL_LEDGER_SET_ASSIGNMENTS gllsa,
1412: GL_SEG_VAL_HIERARCHIES glsvh
1413: WHERE glasna.status_code IN ('I', 'D', 'U')
1414: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1415: AND glasna.all_segment_value_flag = 'Y'

Line 1467: GL_LEDGER_SET_ASSIGNMENTS gllsa,

1463: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1464: glasna.start_date, glasna.end_date
1465: FROM GL_ACCESS_SET_NORM_ASSIGN glasna,
1466: GL_ACCESS_SETS glas,
1467: GL_LEDGER_SET_ASSIGNMENTS gllsa,
1468: GL_SEG_VAL_HIERARCHIES glsvh
1469: WHERE glasna.status_code IN ('I', 'D', 'U')
1470: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1471: AND glasna.all_segment_value_flag = 'N'