DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 484: UPDATE wip_requirement_operations

480: );
481:
482: END IF;
483:
484: UPDATE wip_requirement_operations
485: SET operation_seq_num = (SELECT MIN(operation_seq_num)
486: FROM wip_operations
487: WHERE wip_entity_id = l_wip_entity_id
488: AND organization_id = l_organization_id)

Line 595: FROM wip_requirement_operations wro, mtl_system_items_b msi

591: )
592: OR EXISTS
593: (
594: SELECT 1
595: FROM wip_requirement_operations wro, mtl_system_items_b msi
596: WHERE wro.wip_entity_id = l_wip_entity_id
597: AND wro.organization_id = l_organization_id
598: AND wro.inventory_item_id = msi.inventory_item_id
599: AND wro.organization_id = msi.organization_id