DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on WIP_OPERATIONS

Line 183: , WIP_Operations WO

179: , wdj.primary_item_id
180: , wo.department_id )
181: FROM PO_Distributions_All POD
182: , WIP_Discrete_Jobs WDJ
183: , WIP_Operations WO
184: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
185: AND WO.WIP_Entity_Id = POD.WIP_Entity_Id
186: AND WO.Operation_Seq_Num = POD.WIP_Operation_Seq_Num
187: AND WDJ.WIP_Entity_Id = WO.Wip_Entity_Id;

Line 794: wip_operations WO ,

790: Begin
791: SELECT BD.pa_expenditure_org_id
792: INTO l_exp_org_id
793: FROM PO_DISTRIBUTIONS_ALL POD,
794: wip_operations WO ,
795: bom_departments BD
796: WHERE POD.wip_entity_id = WO.wip_entity_id
797: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
798: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM

Line 1225: wip_operations WO ,

1221: Begin
1222: SELECT BD.pa_expenditure_org_id
1223: INTO l_exp_org_id
1224: FROM PO_DISTRIBUTIONS_ALL POD,
1225: wip_operations WO ,
1226: bom_departments BD
1227: WHERE POD.wip_entity_id = WO.wip_entity_id
1228: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
1229: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM

Line 1665: wip_operations WO ,

1661: Begin
1662: SELECT BD.pa_expenditure_org_id
1663: INTO l_exp_org_id
1664: FROM PO_DISTRIBUTIONS_ALL POD,
1665: wip_operations WO ,
1666: bom_departments BD
1667: WHERE POD.wip_entity_id = WO.wip_entity_id
1668: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
1669: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM

Line 2093: wip_operations WO ,

2089: Begin
2090: SELECT BD.pa_expenditure_org_id
2091: INTO l_exp_org_id
2092: FROM PO_DISTRIBUTIONS_ALL POD,
2093: wip_operations WO ,
2094: bom_departments BD
2095: WHERE POD.wip_entity_id = WO.wip_entity_id
2096: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)
2097: AND POD.wip_operation_seq_num = WO.OPERATION_SEQ_NUM