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_LEDGER_SETS dependencies on GL_LEDGERS

Line 46: FROM GL_LEDGERS

42: DELETE from GL_LEDGER_SET_ASSIGNMENTS
43: WHERE status_code = 'I'
44: AND ledger_set_id IN
45: (SELECT ledger_id
46: FROM GL_LEDGERS
47: WHERE object_type_code = 'S'
48: AND chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
49:
50: row_count := SQL%ROWCOUNT;

Line 75: FROM GL_LEDGERS

71: SET status_code = NULL
72: WHERE status_code = 'D'
73: AND ledger_set_id IN
74: (SELECT ledger_id
75: FROM GL_LEDGERS
76: WHERE object_type_code = 'S'
77: AND chart_of_accounts_id =
78: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
79:

Line 110: FROM GL_LEDGERS

106: DELETE from GL_ACCESS_SET_NORM_ASSIGN
107: WHERE status_code = 'I'
108: AND access_set_id IN
109: (SELECT implicit_access_set_id
110: FROM GL_LEDGERS
111: WHERE object_type_code = 'S'
112: AND chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
113:
114: row_count := SQL%ROWCOUNT;

Line 156: GL_LEDGERS gll

152: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
153: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID,
154: NULL, gllsna.start_date, gllsna.end_date
155: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
156: GL_LEDGERS gll
157: WHERE gllsna.status_code = 'I'
158: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
159: AND gll.ledger_id = gllsna.ledger_set_id
160: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 205: FROM GL_LEDGERS gll

201: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
202: AND glasna.record_id = -1
203: AND glasna.access_set_id IN
204: (SELECT gll.implicit_access_set_id
205: FROM GL_LEDGERS gll
206: WHERE gll.chart_of_accounts_id =
207: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
208: AND gll.automatically_created_flag = 'N'
209: AND gll.object_type_code = 'S');

Line 262: GL_LEDGERS gll,

258: WHERE NVL(gllsa1.status_code, 'X') <> 'D'
259: AND (gllsa1.ledger_set_id, gllsa1.ledger_id) IN
260: (SELECT distinct gllsa2.ledger_set_id, gllsna.ledger_id
261: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
262: GL_LEDGERS gll,
263: GL_LEDGER_SET_ASSIGNMENTS gllsa2
264: WHERE gllsna.status_code = 'D'
265: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
266: AND gll.ledger_id = gllsna.ledger_set_id

Line 300: GL_LEDGERS gll,

296: WHERE NVL(gllsa1.status_code, 'X') <> 'D'
297: AND (gllsa1.ledger_set_id, gllsa1.ledger_id) IN
298: (SELECT distinct gllsa2.ledger_set_id, gllsa3.ledger_id
299: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
300: GL_LEDGERS gll,
301: GL_LEDGER_SET_ASSIGNMENTS gllsa2,
302: GL_LEDGER_SET_ASSIGNMENTS gllsa3
303: WHERE gllsna.status_code = 'D'
304: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

Line 345: FROM GL_LEDGERS gll

341: SET gllsa1.status_code = NULL
342: WHERE gllsa1.status_code = 'D'
343: AND gllsa1.ledger_set_id IN
344: (SELECT gll.ledger_id
345: FROM GL_LEDGERS gll
346: WHERE gll.chart_of_accounts_id =
347: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
348: AND gll.object_type_code = 'S'
349: AND gll.automatically_created_flag = 'N')

Line 409: FROM GL_LEDGERS gll

405: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
407: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
408: NULL, NULL
409: FROM GL_LEDGERS gll
410: WHERE gll.object_type_code = 'S'
411: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
412: AND gll.automatically_created_flag = 'N'
413: AND NOT EXISTS

Line 450: GL_LEDGERS gll,

446: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
447: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
448: NULL, NULL
449: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
450: GL_LEDGERS gll,
451: GL_LEDGER_SET_ASSIGNMENTS gllsa
452: WHERE gllsna.status_code = 'I'
453: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
454: AND gll.ledger_id = gllsna.ledger_id

Line 503: GL_LEDGERS gll,

499: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
500: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
501: NULL, NULL
502: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
503: GL_LEDGERS gll,
504: GL_LEDGER_SET_ASSIGNMENTS gllsa1,
505: GL_LEDGER_SET_ASSIGNMENTS gllsa2
506: WHERE gllsna.status_code = 'I'
507: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

Line 544: GL_LEDGERS gll,

540: FROM DUAL
541: WHERE EXISTS
542: (SELECT 1
543: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa1,
544: GL_LEDGERS gll,
545: GL_LEDGER_SET_ASSIGNMENTS gllsa2
546: WHERE gllsa1.status_code = 'I'
547: AND gll.ledger_id = gllsa1.ledger_set_id
548: AND gll.chart_of_accounts_id =

Line 644: FROM GL_LEDGERS

640: WHERE status_code = 'D'
641: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
642: AND ledger_set_id IN
643: (SELECT ledger_id
644: FROM GL_LEDGERS
645: WHERE object_type_code = 'S'
646: AND chart_of_accounts_id =
647: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
648:

Line 677: FROM GL_LEDGERS

673: WHERE status_code = 'I'
674: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
675: AND ledger_set_id IN
676: (SELECT ledger_id
677: FROM GL_LEDGERS
678: WHERE object_type_code = 'S'
679: AND chart_of_accounts_id =
680: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
681:

Line 707: FROM GL_LEDGERS

703: DELETE from GL_LEDGER_SET_ASSIGNMENTS
704: WHERE status_code = 'D'
705: AND ledger_set_id IN
706: (SELECT ledger_id
707: FROM GL_LEDGERS
708: WHERE object_type_code = 'S'
709: AND chart_of_accounts_id =
710: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
711:

Line 739: FROM GL_LEDGERS

735: SET status_code = NULL
736: WHERE status_code = 'I'
737: AND ledger_set_id IN
738: (SELECT ledger_id
739: FROM GL_LEDGERS
740: WHERE object_type_code = 'S'
741: AND chart_of_accounts_id =
742: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
743: