DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on MTL_UOM_CONVERSIONS

Line 992: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br

988: AND woru.operation_seq_num = wor.operation_seq_num
989: AND woru.resource_seq_num = wor.resource_seq_num
990: AND woru.instance_id IS NOT NULL
991: AND woru.serial_number IS NULL) assigned_hours
992: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br
993: WHERE wor.wip_entity_id = p_wip_entity_id
994: AND wor.resource_id = br.resource_id
995: AND br.resource_type = 2 --for person type resources only
996: AND con.uom_code = wor. uom_code

Line 1018: FROM MTL_UOM_CONVERSIONS CON

1014:
1015:
1016: SELECT CON.CONVERSION_RATE
1017: INTO l_uom_conv
1018: FROM MTL_UOM_CONVERSIONS CON
1019: WHERE CON.UOM_CODE = l_hour_uom
1020: AND NVL(DISABLE_DATE, l_next_date) > l_sysdate
1021: AND CON.INVENTORY_ITEM_ID = l_inv_item_id;
1022: