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 256: gms_encumbrance_items_all enc

252: FROM DUAL
253: WHERE EXISTS
254: (SELECT 'X'
255: FROM gms_award_distributions adl,
256: gms_encumbrance_items_all enc
257: WHERE adl.expenditure_item_id = enc.encumbrance_item_id
258: AND adl.document_type = 'ENC'
259: AND adl.adl_status = 'A'
260: AND adl.award_id = P_AWARD_ID

Line 282: gms_encumbrance_items_all enc1,

278: FROM DUAL
279: WHERE EXISTS
280: (SELECT 'X'
281: FROM gms_award_distributions adl1,
282: gms_encumbrance_items_all enc1,
283: gms_encumbrance_items_all enc2,
284: gms_award_distributions adl2
285: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
286: AND adl1.document_type = 'ENC'

Line 283: gms_encumbrance_items_all enc2,

279: WHERE EXISTS
280: (SELECT 'X'
281: FROM gms_award_distributions adl1,
282: gms_encumbrance_items_all enc1,
283: gms_encumbrance_items_all enc2,
284: gms_award_distributions adl2
285: WHERE adl1.expenditure_item_id = enc1.encumbrance_item_id
286: AND adl1.document_type = 'ENC'
287: AND adl1.adl_status = 'A'

Line 561: FROM gms_encumbrance_items_all enc,

557: SELECT 1
558: FROM DUAL
559: WHERE EXISTS
560: (SELECT 'X'
561: FROM gms_encumbrance_items_all enc,
562: pa_tasks tsk
563: WHERE enc.task_id = tsk.task_id
564: AND tsk.project_id = P_PROJECT_ID
565: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)

Line 585: FROM gms_encumbrance_items_all enc1,

581: SELECT 1
582: FROM DUAL
583: WHERE EXISTS
584: (SELECT 'X'
585: FROM gms_encumbrance_items_all enc1,
586: gms_encumbrance_items_all enc2,
587: pa_tasks tsk
588: WHERE enc1.task_id = tsk.task_id
589: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id

Line 586: gms_encumbrance_items_all enc2,

582: FROM DUAL
583: WHERE EXISTS
584: (SELECT 'X'
585: FROM gms_encumbrance_items_all enc1,
586: gms_encumbrance_items_all enc2,
587: pa_tasks tsk
588: WHERE enc1.task_id = tsk.task_id
589: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
590: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'

Line 815: FROM gms_encumbrance_items_all enc,

811: SELECT 1
812: FROM DUAL
813: WHERE EXISTS
814: (SELECT 'X'
815: FROM gms_encumbrance_items_all enc,
816: pa_tasks tsk
817: WHERE enc.task_id = tsk.task_id
818: AND tsk.project_id = P_PROJECT_ID
819: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)

Line 838: FROM gms_encumbrance_items_all enc1,

834: SELECT 1
835: FROM DUAL
836: WHERE EXISTS
837: (SELECT 'X'
838: FROM gms_encumbrance_items_all enc1,
839: gms_encumbrance_items_all enc2,
840: pa_tasks tsk
841: WHERE enc1.task_id = tsk.task_id
842: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id

Line 839: gms_encumbrance_items_all enc2,

835: FROM DUAL
836: WHERE EXISTS
837: (SELECT 'X'
838: FROM gms_encumbrance_items_all enc1,
839: gms_encumbrance_items_all enc2,
840: pa_tasks tsk
841: WHERE enc1.task_id = tsk.task_id
842: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
843: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'