DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on PJM_PO_COMMITMENTS_V

Line 1007: Checks the PJM PO Commitments View against PA_Commitment_Txns

1003: v_tmp := 'N';
1004: End; -- Eleventh Block, for updated Shop Floor/Inventory Reqs
1005:
1006: /* Twelvth Block: NEW Shop Floor/Inventory POs
1007: Checks the PJM PO Commitments View against PA_Commitment_Txns
1008: for new Shop Floor/Inventory Purchase Orders
1009: */
1010:
1011: v_tmp := 'N';

Line 1022: PJM_PO_COMMITMENTS_V PJPO

1018: WHERE EXISTS
1019: (
1020: SELECT '1'
1021: FROM
1022: PJM_PO_COMMITMENTS_V PJPO
1023: WHERE
1024: PJPO.Project_ID = p_ProjectID
1025: AND NOT EXISTS (
1026: SELECT '2'

Line 1175: Checks the PJM PO Commitments View against PA_Commitment_Txns

1171: End;
1172: End; -- Twelvth Block, for new Shop Floor/Inventory POs
1173:
1174: /* Thirteenth Block: Updated Shop Floor/Inventory POs
1175: Checks the PJM PO Commitments View against PA_Commitment_Txns
1176: for new Shop Floor/Inventory Purchase Orders
1177: */
1178:
1179: v_tmp := 'N';

Line 1198: PJM_PO_COMMITMENTS_V PJPO

1194: AND NOT EXISTS
1195: (
1196: SELECT '2'
1197: FROM
1198: PJM_PO_COMMITMENTS_V PJPO
1199: , PO_HEADERS_ALL POH
1200: , PO_LINE_LOCATIONS_ALL PLL
1201: , PO_DISTRIBUTIONS_ALL POD
1202: , PO_LINES_ALL POL