DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_EAM_DIRECT_ITEMS

Line 493: UPDATE wip_eam_direct_items

489: WHERE wip_entity_id = l_wip_entity_id
490: AND organization_id = l_organization_id
491: AND operation_seq_num = 1;
492:
493: UPDATE wip_eam_direct_items
494: SET operation_seq_num = (SELECT MIN(operation_seq_num)
495: FROM wip_operations
496: WHERE wip_entity_id = l_wip_entity_id
497: AND organization_id = l_organization_id)

Line 588: FROM wip_eam_direct_items wedi

584: FROM DUAL
585: WHERE EXISTS
586: (
587: SELECT 1
588: FROM wip_eam_direct_items wedi
589: WHERE wedi.wip_entity_id = l_wip_entity_id
590: AND wedi.organization_id = l_organization_id
591: )
592: OR EXISTS