APPS.PA_CHECK_COMMITMENTS dependencies on PJM_REQ_COMMITMENTS_V

Line 777: Checks the PJM Req Commitments View against PA_Commitment_Txns

773:
774: /* Added the following four blocks for the bug #3631172. */
775:
776: /* Tenth Block: NEW Shop Floor/Inventory REQUISITIONS
777: Checks the PJM Req Commitments View against PA_Commitment_Txns
778: for new Shop Floor/Inventory Purchase Requisitions.
779: */
780:
781: v_tmp := 'N';

Line 791: PJM_REQ_COMMITMENTS_V PJREQ

787: FROM DUAL
788: WHERE EXISTS (
789: SELECT '1'
790: FROM
791: PJM_REQ_COMMITMENTS_V PJREQ
792: WHERE
793: PJREQ.Project_ID = p_ProjectID
794: AND NOT EXISTS (
795: SELECT '2'

Line 945: Checks the PJM Req Commitments View against PA_Commitment_Txns

941: End;
942: End; -- Tenth Block, for new Shop Floor/Inventory Reqs
943:
944: /* Eleventh Block: UPDATED Shop Floor/Inventory REQUISTIONS
945: Checks the PJM Req Commitments View against PA_Commitment_Txns
946: for updated Shop Floor/Inventory Purchase Requisitions.
947:
948: */
949:

Line 969: PJM_REQ_COMMITMENTS_V PJREQ

965: AND NOT EXISTS
966: (
967: SELECT '2'
968: FROM
969: PJM_REQ_COMMITMENTS_V PJREQ
970: WHERE PJREQ.PROJECT_ID = p_ProjectID
971: AND CMT.task_id = nvl(PJREQ.task_id,0)
972: AND CMT.cmt_distribution_id = PJREQ.REQ_DISTRIBUTION_ID
973: AND CMT.description = PJREQ.item_description