APPS.PA_CHECK_COMMITMENTS dependencies on PO_REQUISITION_LINES_ALL

Line 131: , PO_REQUISITION_LINES_ALL RL

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 */
135: , PO_LINE_TYPES_B LT /* modified for bug 6367516 */

Line 588: , PO_REQUISITION_LINES_ALL RL

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 */
592: , PER_ALL_PEOPLE_F REQ

Line 826: , PO_REQUISITION_LINES_ALL RL

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
830: WHERE RL.DESTINATION_TYPE_CODE = 'INVENTORY'

Line 844: , PO_REQUISITION_LINES_ALL RL

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
848: , BOM_DEPARTMENTS BD

Line 896: , PO_REQUISITION_LINES_ALL RL

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'
900: AND RD.PROJECT_ID = p_ProjectID

Line 910: , PO_REQUISITION_LINES_ALL RL

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
914: , MTL_UNITS_OF_MEASURE_VL UOM