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'
831: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
832: AND RD.PROJECT_ID IS NULL
833: AND POP.COMMON_PROJECT_ID = p_ProjectID
845: , PJM_ORG_PARAMETERS POP
846: , WIP_DISCRETE_JOBS WDJ
847: , WIP_OPERATIONS WO
848: , BOM_DEPARTMENTS BD
849: , MTL_UNITS_OF_MEASURE_VL UOM
850: WHERE RL.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
851: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
852: AND RD.PROJECT_ID IS NULL
853: AND POP.COMMON_PROJECT_ID = p_ProjectID
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
901: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
902: AND MSI.ORGANIZATION_ID = RL.DESTINATION_ORGANIZATION_ID
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
915: WHERE RL.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
916: AND RD.PROJECT_ID = p_ProjectID
917: AND RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
918: AND WDJ.ORGANIZATION_ID = RL.DESTINATION_ORGANIZATION_ID
1055: FROM PO_DISTRIBUTIONS_ALL POD
1056: , PO_LINES_ALL POL
1057: , PJM_ORG_PARAMETERS POP
1058: , MTL_SYSTEM_ITEMS MSI
1059: , MTL_UNITS_OF_MEASURE_VL UOM
1060: WHERE POD.DESTINATION_TYPE_CODE = 'INVENTORY'
1061: AND POL.PO_LINE_ID = POD.PO_LINE_ID
1062: AND POD.PROJECT_ID IS NULL
1063: AND POP.COMMON_PROJECT_ID = p_ProjectID
1075: , PJM_ORG_PARAMETERS POP
1076: , WIP_DISCRETE_JOBS WDJ
1077: , WIP_OPERATIONS WO
1078: , BOM_DEPARTMENTS BD
1079: , MTL_UNITS_OF_MEASURE_VL UOM
1080: WHERE POD.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
1081: AND POL.PO_LINE_ID = POD.PO_LINE_ID
1082: AND POL.PROJECT_ID IS NULL
1083: AND POP.COMMON_PROJECT_ID = p_ProjectID
1124: POD.PO_DISTRIBUTION_ID
1125: FROM PO_DISTRIBUTIONS_ALL POD
1126: , PO_LINES_ALL POL
1127: , MTL_SYSTEM_ITEMS MSI
1128: , MTL_UNITS_OF_MEASURE_VL UOM
1129: WHERE POD.DESTINATION_TYPE_CODE = 'INVENTORY'
1130: AND POD.PROJECT_ID = p_ProjectID
1131: AND POL.PO_LINE_ID = POD.PO_LINE_ID
1132: AND MSI.ORGANIZATION_ID = POD.DESTINATION_ORGANIZATION_ID
1140: , PO_LINES_ALL POL
1141: , WIP_DISCRETE_JOBS WDJ
1142: , WIP_OPERATIONS WO
1143: , BOM_DEPARTMENTS BD
1144: , MTL_UNITS_OF_MEASURE_VL UOM
1145: WHERE POD.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
1146: AND POD.PROJECT_ID = p_ProjectID
1147: AND POL.PO_LINE_ID = POD.PO_LINE_ID
1148: AND WDJ.ORGANIZATION_ID = POD.DESTINATION_ORGANIZATION_ID