DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 526: UPDATE wip_requirement_operations

522: );
523:
524: END IF;
525:
526: UPDATE wip_requirement_operations
527: SET operation_seq_num = (SELECT MIN(operation_seq_num)
528: FROM wip_operations
529: WHERE wip_entity_id = l_wip_entity_id
530: AND organization_id = l_organization_id)

Line 640: FROM wip_requirement_operations wro, mtl_system_items_b msi

636: )
637: OR EXISTS
638: (
639: SELECT 1
640: FROM wip_requirement_operations wro, mtl_system_items_b msi
641: WHERE wro.wip_entity_id = l_wip_entity_id
642: AND wro.organization_id = l_organization_id
643: AND wro.inventory_item_id = msi.inventory_item_id
644: AND wro.organization_id = msi.organization_id