APPS.PA_CHECK_COMMITMENTS dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 130: PO_REQ_DISTRIBUTIONS_ALL RD

126: FROM DUAL
127: WHERE EXISTS (
128: SELECT '1'
129: FROM
130: PO_REQ_DISTRIBUTIONS_ALL RD
131: , PO_REQUISITION_LINES_ALL RL
132: , PER_ALL_PEOPLE_F REQ
133: , PO_REQUISITION_HEADERS_ALL RH
134: , PO_DOCUMENT_TYPES_ALL_TL PDT /* modified for bug 4758887 */

Line 587: PO_REQ_DISTRIBUTIONS_ALL RD

583: AND NOT EXISTS
584: (
585: SELECT '2'
586: FROM
587: PO_REQ_DISTRIBUTIONS_ALL RD
588: , PO_REQUISITION_LINES_ALL RL
589: , PO_REQUISITION_HEADERS_ALL RH
590: , PO_DOCUMENT_TYPES_ALL_TL PDT /* modified for bug 4758887 */
591: , PO_LINE_TYPES_B LT /* modified for bug 6367516 */

Line 825: FROM PO_REQ_DISTRIBUTIONS_ALL RD

821: from (
822: SELECT RL.REQUISITION_HEADER_ID,
823: RL.LINE_NUM,
824: RD.DISTRIBUTION_ID
825: FROM PO_REQ_DISTRIBUTIONS_ALL RD
826: , PO_REQUISITION_LINES_ALL RL
827: , PJM_ORG_PARAMETERS POP
828: , MTL_SYSTEM_ITEMS MSI
829: , MTL_UNITS_OF_MEASURE_VL UOM

Line 843: FROM PO_REQ_DISTRIBUTIONS_ALL RD

839: UNION ALL
840: SELECT RL.REQUISITION_HEADER_ID,
841: RL.LINE_NUM,
842: RD.DISTRIBUTION_ID
843: FROM PO_REQ_DISTRIBUTIONS_ALL RD
844: , PO_REQUISITION_LINES_ALL RL
845: , PJM_ORG_PARAMETERS POP
846: , WIP_DISCRETE_JOBS WDJ
847: , WIP_OPERATIONS WO

Line 895: FROM PO_REQ_DISTRIBUTIONS_ALL RD

891: from (
892: SELECT RL.REQUISITION_HEADER_ID,
893: RL.LINE_NUM,
894: RD.DISTRIBUTION_ID
895: FROM PO_REQ_DISTRIBUTIONS_ALL RD
896: , PO_REQUISITION_LINES_ALL RL
897: , MTL_SYSTEM_ITEMS MSI
898: , MTL_UNITS_OF_MEASURE_VL UOM
899: WHERE RL.DESTINATION_TYPE_CODE = 'INVENTORY'

Line 909: FROM PO_REQ_DISTRIBUTIONS_ALL RD

905: UNION ALL
906: SELECT RL.REQUISITION_HEADER_ID,
907: RL.LINE_NUM,
908: RD.DISTRIBUTION_ID
909: FROM PO_REQ_DISTRIBUTIONS_ALL RD
910: , PO_REQUISITION_LINES_ALL RL
911: , WIP_DISCRETE_JOBS WDJ
912: , WIP_OPERATIONS WO
913: , BOM_DEPARTMENTS BD