DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_EAM_DIRECT_ITEMS

Line 535: UPDATE wip_eam_direct_items

531: WHERE wip_entity_id = l_wip_entity_id
532: AND organization_id = l_organization_id
533: AND operation_seq_num = 1;
534:
535: UPDATE wip_eam_direct_items
536: SET operation_seq_num = (SELECT MIN(operation_seq_num)
537: FROM wip_operations
538: WHERE wip_entity_id = l_wip_entity_id
539: AND organization_id = l_organization_id)

Line 633: FROM wip_eam_direct_items wedi

629: FROM DUAL
630: WHERE EXISTS
631: (
632: SELECT 1
633: FROM wip_eam_direct_items wedi
634: WHERE wedi.wip_entity_id = l_wip_entity_id
635: AND wedi.organization_id = l_organization_id
636: )
637: OR EXISTS