DBA Data[Home] [Help]

APPS.PJM_TASK_AUTO_ASSIGN dependencies on WIP_OPERATIONS

Line 868: , wip_operations o

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
872: AND o.organization_id (+) = t.organization_id

Line 1203: , wip_operations o

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
1207: AND o.wip_entity_id = e.wip_entity_id