APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 786: UPDATE WIP_OPERATION_RESOURCES

782: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative resource duration') ; END IF ;
783: return;
784: end if;
785:
786: UPDATE WIP_OPERATION_RESOURCES
787: SET START_DATE = l_res_start_date,
788: COMPLETION_DATE = l_res_completion_date
789: WHERE WIP_ENTITY_ID = p_wip_entity_id
790: AND OPERATION_SEQ_NUM = p_op_seq_num

Line 928: WIP_OPERATION_RESOURCES WOR,

924: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
925: FROM WIP_OPERATIONS WO,
926: BOM_DEPARTMENT_RESOURCES DR1,
927: BOM_DEPARTMENT_RESOURCES DR2,
928: WIP_OPERATION_RESOURCES WOR,
929: BOM_RESOURCES RES,
930: MTL_UOM_CONVERSIONS CON
931: WHERE
932: WO.WIP_ENTITY_ID = p_wip_entity_id

Line 1034: WIP_OPERATION_RESOURCES WOR,

1030: SHF.TO_TIME TO_TIME
1031: FROM BOM_SHIFT_TIMES SHF,
1032: BOM_RESOURCE_SHIFTS RSH,
1033: BOM_DEPARTMENT_RESOURCES BDR,
1034: WIP_OPERATION_RESOURCES WOR,
1035: WIP_OPERATIONS WO
1036: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1037: AND WO.ORGANIZATION_ID = p_organization_id
1038: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID

Line 1059: WIP_OPERATION_RESOURCES WOR,

1055: SHF.TO_TIME TO_TIME
1056: FROM BOM_SHIFT_TIMES SHF,
1057: BOM_RESOURCE_SHIFTS RSH,
1058: BOM_DEPARTMENT_RESOURCES BDR,
1059: WIP_OPERATION_RESOURCES WOR,
1060: WIP_OPERATIONS WO
1061: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1062: AND WO.ORGANIZATION_ID = p_organization_id
1063: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID

Line 1577: FROM wip_operation_resources

1573: resource_seq_num,
1574: start_date,
1575: completion_date,
1576: assigned_units
1577: FROM wip_operation_resources
1578: WHERE wip_entity_id = p_wip_entity_id
1579: AND organization_id = p_organization_id
1580: AND usage_rate_or_amount = 0 ;
1581: