DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_OPERATIONS

Line 528: FROM wip_operations

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

Line 537: FROM wip_operations

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

Line 1076: WIP_OPERATIONS WO

1072: CURSOR Cdisc IS
1073: SELECT WOR.OPERATION_SEQ_NUM,
1074: WOR.RESOURCE_SEQ_NUM
1075: FROM WIP_OPERATION_RESOURCES WOR,
1076: WIP_OPERATIONS WO
1077: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1078: AND WO.ORGANIZATION_ID = p_organization_id
1079: AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
1080: AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID