DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on WIP_OPERATIONS

Line 847: , WIP_OPERATIONS WO

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
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

Line 912: , WIP_OPERATIONS WO

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
915: WHERE RL.DESTINATION_TYPE_CODE = 'SHOP FLOOR'
916: AND RD.PROJECT_ID = p_ProjectID

Line 1077: , WIP_OPERATIONS WO

1073: FROM PO_DISTRIBUTIONS_ALL POD
1074: , PO_LINES_ALL POL
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

Line 1142: , WIP_OPERATIONS WO

1138: POD.PO_DISTRIBUTION_ID
1139: FROM PO_DISTRIBUTIONS_ALL POD
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