DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on MTL_UNITS_OF_MEASURE_VL

Line 829: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 849: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 898: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 914: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 1059: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 1079: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 1128: , MTL_UNITS_OF_MEASURE_VL UOM

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

Line 1144: , MTL_UNITS_OF_MEASURE_VL UOM

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