DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_OPERATIONS

Line 486: FROM wip_operations

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)
489: WHERE wip_entity_id = l_wip_entity_id
490: AND organization_id = l_organization_id

Line 495: FROM wip_operations

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)
498: WHERE wip_entity_id = l_wip_entity_id
499: AND organization_id = l_organization_id

Line 1029: WIP_OPERATIONS WO

1025: CURSOR Cdisc IS
1026: SELECT WOR.OPERATION_SEQ_NUM,
1027: WOR.RESOURCE_SEQ_NUM
1028: FROM WIP_OPERATION_RESOURCES WOR,
1029: WIP_OPERATIONS WO
1030: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1031: AND WO.ORGANIZATION_ID = p_organization_id
1032: AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
1033: AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID