[Home] [Help]
653: End; -- Seventh Block, for updated PO Reqs
654:
655:
656: /* Eighth Block: UPDATED MFG COMMITMENTS
657: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns
658: for updated commitments
659:
660: Note: For MFG commitments, the view returns both acct and denom amounts for most amount
661: columns, So, where possible, joins are performed for denom amounts.
677: AND CMT.Transaction_Source = 'ORACLE_MANUFACTURING'
678: AND NOT EXISTS
679: (
680: SELECT '2'
681: FROM CST_PROJMFG_CMT_VIEW CST
682: WHERE
683: CST.Project_ID = p_ProjectID
684: AND CMT.task_id = nvl(CST.task_id,0)
685: AND nvl(CMT.CMT_Header_ID,0) = nvl(CST.CMT_Header_ID,0)
731:
732: Exception
733: WHEN NO_DATA_FOUND THEN
734: v_tmp := 'N';
735: End; -- Eighth Block, for updated commitments from CST_PROJMFG_CMT_VIEW
736:
737:
738: /* Ninth Block: NEW MFG COMMITMENTS
739: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns
735: End; -- Eighth Block, for updated commitments from CST_PROJMFG_CMT_VIEW
736:
737:
738: /* Ninth Block: NEW MFG COMMITMENTS
739: Checks the CST_PROJMFG_CMT_VIEW against PA_Commitment_Txns
740: for new commitments
741: */
742:
743: v_tmp := 'N';
749: FROM DUAL
750: WHERE EXISTS (
751: SELECT '1'
752: FROM
753: CST_PROJMFG_CMT_VIEW CST
754: WHERE
755: CST.PROJECT_ID = p_ProjectID
756: AND NOT EXISTS (
757: SELECT '2'
768:
769: Exception
770: WHEN NO_DATA_FOUND THEN
771: v_tmp := 'N';
772: End; -- Ninth Block, for new commitments from CST_PROJMFG_CMT_VIEW
773:
774: /* Added the following four blocks for the bug #3631172. */
775:
776: /* Tenth Block: NEW Shop Floor/Inventory REQUISITIONS