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_SEG_VAL_HIERARCHIES

Line 775: FROM GL_SEG_VAL_HIERARCHIES glsvh

771: INTO row_count
772: FROM DUAL
773: WHERE EXISTS
774: (SELECT 1
775: FROM GL_SEG_VAL_HIERARCHIES glsvh
776: WHERE glsvh.flex_value_set_id =
777: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
778: AND glsvh.parent_flex_value = 'T'
779: AND glsvh.status_code = 'I');

Line 959: FROM GL_SEG_VAL_HIERARCHIES glsvh,

955: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
956: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
957: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
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

Line 1027: FROM GL_SEG_VAL_HIERARCHIES glsvh,

1023: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
1024: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
1025: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
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

Line 1128: -- This statement will not join to GL_SEG_VAL_HIERARCHIES since

1124: 'or access assignment with a single segment '||
1125: 'value...');
1126: END IF;
1127:
1128: -- This statement will not join to GL_SEG_VAL_HIERARCHIES since
1129: -- it only process changes in explicit ledger sets in full ledger
1130: -- type access sets, or access assignment with a single segment value.
1131: INSERT into GL_ACCESS_SET_ASSIGN_INT
1132: (access_set_id, ledger_id, segment_value, access_privilege_code,

Line 1195: GL_SEG_VAL_HIERARCHIES glsvh

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
1196: WHERE gllsa.status_code IN ('I', 'D')
1197: AND gll.ledger_id = gllsa.ledger_set_id
1198: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1199: AND gll.object_type_code = 'S'

Line 1247: GL_SEG_VAL_HIERARCHIES glsvh

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
1248: WHERE gllsa.status_code IN ('I', 'D')
1249: AND gll.ledger_id = gllsa.ledger_set_id
1250: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1251: AND gll.object_type_code = 'S'

Line 1412: GL_SEG_VAL_HIERARCHIES glsvh

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'
1416: AND glas.access_set_id = glasna.access_set_id

Line 1468: GL_SEG_VAL_HIERARCHIES glsvh

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'
1472: AND glasna.segment_value_type_code = 'C'