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_ACCESS_SETS

Line 107: FROM GL_ACCESS_SETS

103: DELETE from GL_ACCESS_SET_NORM_ASSIGN
104: WHERE status_code = 'I'
105: AND access_set_id IN
106: (SELECT access_set_id
107: FROM GL_ACCESS_SETS
108: WHERE chart_of_accounts_id =
109: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
110: AND automatically_created_flag = 'Y');
111:

Line 137: FROM GL_ACCESS_SETS

133: SET status_code = NULL
134: WHERE status_code IN ('D', 'U')
135: AND access_set_id IN
136: (SELECT access_set_id
137: FROM GL_ACCESS_SETS
138: WHERE chart_of_accounts_id =
139: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
140: AND automatically_created_flag = 'Y');
141:

Line 577: FROM GL_ACCESS_SETS glas,

573: BEGIN
574:
575: SELECT 1
576: INTO row_count
577: FROM GL_ACCESS_SETS glas,
578: GL_ACCESS_SET_ASSIGN_INT glasai,
579: GL_ACCESS_SET_ASSIGNMENTS glasa1,
580: GL_ACCESS_SET_ASSIGNMENTS glasa2
581: WHERE ( glas.secured_seg_value_set_id =

Line 623: FROM GL_ACCESS_SETS glas,

619:
620: DECLARE
621: CURSOR overlap_dates_cursor IS
622: SELECT distinct glas.name, gll.name, glasa1.segment_value
623: FROM GL_ACCESS_SETS glas,
624: GL_ACCESS_SET_ASSIGN_INT glasai,
625: GL_ACCESS_SET_ASSIGNMENTS glasa1,
626: GL_ACCESS_SET_ASSIGNMENTS glasa2,
627: GL_LEDGERS gll

Line 789: FROM GL_ACCESS_SETS glas,

785: INTO row_count
786: FROM DUAL
787: WHERE EXISTS
788: (SELECT 1
789: FROM GL_ACCESS_SETS glas,
790: GL_ACCESS_SET_NORM_ASSIGN glasna
791: WHERE glas.secured_seg_value_set_id =
792: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
793: AND glas.security_segment_code <> 'F'

Line 845: FROM GL_ACCESS_SETS glas,

841: INTO row_count
842: FROM DUAL
843: WHERE EXISTS
844: (SELECT 1
845: FROM GL_ACCESS_SETS glas,
846: GL_ACCESS_SET_NORM_ASSIGN glasna
847: WHERE glas.chart_of_accounts_id =
848: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
849: AND glas.automatically_created_flag = 'N'

Line 868: FROM GL_ACCESS_SETS glas,

864: INTO row_count
865: FROM DUAL
866: WHERE EXISTS
867: (SELECT 1
868: FROM GL_ACCESS_SETS glas,
869: GL_ACCESS_SET_NORM_ASSIGN glasna
870: WHERE glas.chart_of_accounts_id =
871: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
872: AND glas.automatically_created_flag = 'N'

Line 890: FROM GL_ACCESS_SETS glas,

886: INTO row_count
887: FROM DUAL
888: WHERE EXISTS
889: (SELECT 1
890: FROM GL_ACCESS_SETS glas,
891: GL_ACCESS_SET_NORM_ASSIGN glasna
892: WHERE glas.chart_of_accounts_id =
893: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
894: AND glas.automatically_created_flag = 'N'

Line 960: GL_ACCESS_SETS glas,

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
964: AND glsvh.status_code in ('I', 'D')

Line 1028: GL_ACCESS_SETS glas,

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
1032: AND glsvh.parent_flex_value = 'T'

Line 1145: GL_ACCESS_SETS glas

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')
1147: AND gll.ledger_id = gllsa.ledger_set_id
1148: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1149: AND gll.object_type_code = 'S'

Line 1194: GL_ACCESS_SETS glas,

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
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

Line 1246: GL_ACCESS_SETS glas,

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
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

Line 1356: GL_ACCESS_SETS glas,

1352: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
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

Line 1410: GL_ACCESS_SETS glas,

1406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
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

Line 1466: GL_ACCESS_SETS glas,

1462: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
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

Line 1549: GL_ACCESS_SETS glas

1545: CURSOR dup_access_assign_cursor IS
1546: SELECT DISTINCT MIN(glasai.access_set_id),
1547: MIN(glasai.ledger_id), MIN(glasai.segment_value)
1548: FROM GL_ACCESS_SET_ASSIGN_INT glasai,
1549: GL_ACCESS_SETS glas
1550: WHERE glasai.status_code = 'I'
1551: AND glasai.access_set_id > 0
1552: AND glas.access_set_id = ABS(glasai.access_set_id)
1553: AND glas.automatically_created_flag = 'N'

Line 1703: GL_ACCESS_SETS glas,

1699: SET glasai1.access_set_id = -glasai1.access_set_id
1700: WHERE glasai1.rowid IN
1701: (SELECT glasai2.rowid
1702: FROM GL_ACCESS_SET_ASSIGN_INT glasai2,
1703: GL_ACCESS_SETS glas,
1704: GL_ACCESS_SET_ASSIGNMENTS glasa
1705: WHERE glasai2.status_code = 'I'
1706: AND glasai2.access_set_id > 0
1707: AND glas.access_set_id = glasai2.access_set_id

Line 1784: GL_ACCESS_SETS glas

1780: AND glasai1.status_code = 'I'
1781: AND EXISTS
1782: (SELECT 1
1783: FROM GL_ACCESS_SET_ASSIGN_INT glasai2,
1784: GL_ACCESS_SETS glas
1785: WHERE glasai2.status_code IN ('I', 'U')
1786: AND glasai2.access_set_id = glasai1.access_set_id
1787: AND glasai2.ledger_id = glasai1.ledger_id
1788: AND glasai2.segment_value = glasai1.segment_value

Line 1852: GL_ACCESS_SETS glas

1848: (SELECT DISTINCT
1849: glasai.access_set_id, glasai.ledger_id,
1850: glasai.segment_value
1851: FROM GL_ACCESS_SET_ASSIGN_INT glasai,
1852: GL_ACCESS_SETS glas
1853: WHERE glasai.status_code IN ('I', 'U')
1854: AND glasai.access_privilege_code = 'B'
1855: AND glasai.access_set_id > 0
1856: AND glas.access_set_id = glasai.access_set_id

Line 1919: FROM GL_ACCESS_SETS

1915: WHERE status_code = 'D'
1916: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1917: AND access_set_id IN
1918: (SELECT access_set_id
1919: FROM GL_ACCESS_SETS
1920: WHERE chart_of_accounts_id =
1921: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1922: AND automatically_created_flag = 'N');
1923:

Line 1978: FROM GL_ACCESS_SETS

1974: WHERE status_code IN ('I', 'U')
1975: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
1976: AND access_set_id IN
1977: (SELECT access_set_id
1978: FROM GL_ACCESS_SETS
1979: WHERE chart_of_accounts_id =
1980: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
1981: AND automatically_created_flag = 'N');
1982: