APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATION_RESOURCES

Line 805: UPDATE WIP_OPERATION_RESOURCES

801: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Negative resource duration') ; END IF ;
802: return;
803: end if;
804:
805: UPDATE WIP_OPERATION_RESOURCES
806: SET START_DATE = l_res_start_date,
807: COMPLETION_DATE = l_res_completion_date
808: WHERE WIP_ENTITY_ID = p_wip_entity_id
809: AND OPERATION_SEQ_NUM = p_op_seq_num

Line 947: WIP_OPERATION_RESOURCES WOR,

943: DR2.AVAILABLE_24_HOURS_FLAG AVAIL_24_HRS_FLAG
944: FROM WIP_OPERATIONS WO,
945: BOM_DEPARTMENT_RESOURCES DR1,
946: BOM_DEPARTMENT_RESOURCES DR2,
947: WIP_OPERATION_RESOURCES WOR,
948: BOM_RESOURCES RES,
949: MTL_UOM_CONVERSIONS CON
950: WHERE
951: WO.WIP_ENTITY_ID = p_wip_entity_id

Line 1053: WIP_OPERATION_RESOURCES WOR,

1049: SHF.TO_TIME TO_TIME
1050: FROM BOM_SHIFT_TIMES SHF,
1051: BOM_RESOURCE_SHIFTS RSH,
1052: BOM_DEPARTMENT_RESOURCES BDR,
1053: WIP_OPERATION_RESOURCES WOR,
1054: WIP_OPERATIONS WO
1055: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1056: AND WO.ORGANIZATION_ID = p_organization_id
1057: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID

Line 1078: WIP_OPERATION_RESOURCES WOR,

1074: SHF.TO_TIME TO_TIME
1075: FROM BOM_SHIFT_TIMES SHF,
1076: BOM_RESOURCE_SHIFTS RSH,
1077: BOM_DEPARTMENT_RESOURCES BDR,
1078: WIP_OPERATION_RESOURCES WOR,
1079: WIP_OPERATIONS WO
1080: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1081: AND WO.ORGANIZATION_ID = p_organization_id
1082: AND WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID

Line 1596: FROM wip_operation_resources

1592: resource_seq_num,
1593: start_date,
1594: completion_date,
1595: assigned_units
1596: FROM wip_operation_resources
1597: WHERE wip_entity_id = p_wip_entity_id
1598: AND organization_id = p_organization_id
1599: AND usage_rate_or_amount = 0 ;
1600: