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.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on GMS_ENCUMBRANCE_ITEMS_ALL

Line 40: gms_encumbrance_items_all enc

36: FROM DUAL
37: WHERE EXISTS
38: (SELECT 'X'
39: FROM gms_award_distributions adl,
40: gms_encumbrance_items_all enc
41: WHERE adl.expenditure_item_id = enc.encumbrance_item_id
42: AND adl.document_type = 'ENC'
43: AND adl.adl_status = 'A'
44: AND adl.award_id = P_AWARD_ID

Line 66: gms_encumbrance_items_all enc1,

62: FROM DUAL
63: WHERE EXISTS
64: (SELECT 'X'
65: FROM gms_award_distributions adl1,
66: gms_encumbrance_items_all enc1,
67: gms_encumbrance_items_all enc2,
68: gms_award_distributions adl2
69: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
70: AND adl1.document_type = 'ENC'

Line 67: gms_encumbrance_items_all enc2,

63: WHERE EXISTS
64: (SELECT 'X'
65: FROM gms_award_distributions adl1,
66: gms_encumbrance_items_all enc1,
67: gms_encumbrance_items_all enc2,
68: gms_award_distributions adl2
69: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
70: AND adl1.document_type = 'ENC'
71: AND adl1.adl_status = 'A'

Line 265: gms_encumbrance_items_all enc

261: FROM DUAL
262: WHERE EXISTS
263: (SELECT 'X'
264: FROM gms_award_distributions adl,
265: gms_encumbrance_items_all enc
266: WHERE adl.expenditure_item_id = enc.encumbrance_item_id
267: AND adl.document_type = 'ENC'
268: AND adl.adl_status = 'A'
269: AND adl.award_id = P_AWARD_ID

Line 291: gms_encumbrance_items_all enc1,

287: FROM DUAL
288: WHERE EXISTS
289: (SELECT 'X'
290: FROM gms_award_distributions adl1,
291: gms_encumbrance_items_all enc1,
292: gms_encumbrance_items_all enc2,
293: gms_award_distributions adl2
294: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
295: AND adl1.document_type = 'ENC'

Line 292: gms_encumbrance_items_all enc2,

288: WHERE EXISTS
289: (SELECT 'X'
290: FROM gms_award_distributions adl1,
291: gms_encumbrance_items_all enc1,
292: gms_encumbrance_items_all enc2,
293: gms_award_distributions adl2
294: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
295: AND adl1.document_type = 'ENC'
296: AND adl1.adl_status = 'A'

Line 579: FROM gms_encumbrance_items_all enc,

575: SELECT 1
576: FROM DUAL
577: WHERE EXISTS
578: (SELECT 'X'
579: FROM gms_encumbrance_items_all enc,
580: pa_tasks tsk
581: WHERE enc.task_id = tsk.task_id
582: AND tsk.project_id = P_PROJECT_ID
583: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)

Line 603: FROM gms_encumbrance_items_all enc1,

599: SELECT 1
600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'X'
603: FROM gms_encumbrance_items_all enc1,
604: gms_encumbrance_items_all enc2,
605: pa_tasks tsk
606: WHERE enc1.task_id = tsk.task_id
607: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id

Line 604: gms_encumbrance_items_all enc2,

600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'X'
603: FROM gms_encumbrance_items_all enc1,
604: gms_encumbrance_items_all enc2,
605: pa_tasks tsk
606: WHERE enc1.task_id = tsk.task_id
607: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
608: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'

Line 622: FROM gms_encumbrance_items_all enc1,

618: SELECT 1
619: FROM DUAL
620: WHERE EXISTS
621: (SELECT 'X'
622: FROM gms_encumbrance_items_all enc1,
623: -- gms_encumbrance_items_all enc2,
624: pa_tasks tsk
625: WHERE enc1.task_id = tsk.task_id
626: -- AND enc2.adjusted_encumbrance_item_id =enc1.encumbrance_item_id

Line 623: -- gms_encumbrance_items_all enc2,

619: FROM DUAL
620: WHERE EXISTS
621: (SELECT 'X'
622: FROM gms_encumbrance_items_all enc1,
623: -- gms_encumbrance_items_all enc2,
624: pa_tasks tsk
625: WHERE enc1.task_id = tsk.task_id
626: -- AND enc2.adjusted_encumbrance_item_id =enc1.encumbrance_item_id
627: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'

Line 861: FROM gms_encumbrance_items_all enc,

857: SELECT 1
858: FROM DUAL
859: WHERE EXISTS
860: (SELECT 'X'
861: FROM gms_encumbrance_items_all enc,
862: pa_tasks tsk
863: WHERE enc.task_id = tsk.task_id
864: AND tsk.project_id = P_PROJECT_ID
865: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)

Line 884: FROM gms_encumbrance_items_all enc1,

880: SELECT 1
881: FROM DUAL
882: WHERE EXISTS
883: (SELECT 'X'
884: FROM gms_encumbrance_items_all enc1,
885: gms_encumbrance_items_all enc2,
886: pa_tasks tsk
887: WHERE enc1.task_id = tsk.task_id
888: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id

Line 885: gms_encumbrance_items_all enc2,

881: FROM DUAL
882: WHERE EXISTS
883: (SELECT 'X'
884: FROM gms_encumbrance_items_all enc1,
885: gms_encumbrance_items_all enc2,
886: pa_tasks tsk
887: WHERE enc1.task_id = tsk.task_id
888: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
889: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'

Line 905: FROM gms_encumbrance_items_all enc1,

901: SELECT 1
902: FROM DUAL
903: WHERE EXISTS
904: (SELECT 'X'
905: FROM gms_encumbrance_items_all enc1,
906: -- gms_encumbrance_items_all enc2,
907: pa_tasks tsk
908: WHERE enc1.task_id = tsk.task_id
909: -- AND enc2.adjusted_encumbrance_item_id =enc1.encumbrance_item_id

Line 906: -- gms_encumbrance_items_all enc2,

902: FROM DUAL
903: WHERE EXISTS
904: (SELECT 'X'
905: FROM gms_encumbrance_items_all enc1,
906: -- gms_encumbrance_items_all enc2,
907: pa_tasks tsk
908: WHERE enc1.task_id = tsk.task_id
909: -- AND enc2.adjusted_encumbrance_item_id =enc1.encumbrance_item_id
910: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'