APPS.PJM_TASK_AUTO_ASSIGN dependencies on WIP_ENTITIES

Line 456: FROM wip_entities

452: CURSOR c_wip ( C_org_id NUMBER
453: , C_wip_entity_id NUMBER )
454: IS
455: SELECT wip_entity_name
456: FROM wip_entities
457: WHERE organization_id = C_org_id
458: AND wip_entity_id = C_wip_entity_id;
459:
460: BEGIN

Line 652: FROM wip_entities

648: CURSOR c_wip ( C_org_id NUMBER
649: , C_wip_entity_id NUMBER )
650: IS
651: SELECT wip_entity_name
652: FROM wip_entities
653: WHERE organization_id = C_org_id
654: AND wip_entity_id = C_wip_entity_id;
655:
656: BEGIN

Line 867: , wip_entities e

863: , e.primary_item_id
864: , t.department_id
865: , o.standard_operation_id
866: FROM mtl_material_transactions t
867: , wip_entities e
868: , wip_operations o
869: WHERE transaction_id = C_transaction_id
870: AND e.organization_id = t.organization_id
871: AND e.wip_entity_id = t.transaction_source_id

Line 1189: , wip_entities e

1185: , e.primary_item_id
1186: , e.entity_type
1187: , wta.cost_element_id /*Added for Bug 7028109 (FP of 6820737)*/
1188: FROM wip_transactions t
1189: , wip_entities e
1190: , wip_transaction_accounts wta
1191: WHERE t.transaction_id = C_transaction_id
1192: AND t.wip_entity_id = e.wip_entity_id
1193: AND t.organization_id = e.organization_id

Line 1202: FROM wip_entities e

1198: -- for discrete job
1199: CURSOR d1 ( C_organization_id NUMBER, C_wip_entity_id NUMBER, C_operation_seq_num NUMBER )
1200: IS
1201: SELECT o.standard_operation_id
1202: FROM wip_entities e
1203: , wip_operations o
1204: WHERE e.organization_id = C_organization_id
1205: AND e.wip_entity_id = C_wip_entity_id
1206: AND o.organization_id = e.organization_id