DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on MTL_UOM_CONVERSIONS

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

3179: AND woru.operation_seq_num = wor.operation_seq_num
3180: AND woru.resource_seq_num = wor.resource_seq_num
3181: AND woru.instance_id IS NOT NULL
3182: AND woru.serial_number IS NULL) assigned_hours
3183: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br
3184: WHERE wor.wip_entity_id = p_wip_entity_id
3185: AND wor.resource_id = br.resource_id
3186: AND br.resource_type = 2 --for person type resources only
3187: AND con.uom_code = wor. uom_code

Line 3209: FROM MTL_UOM_CONVERSIONS CON

3205:
3206:
3207: SELECT CON.CONVERSION_RATE
3208: INTO l_uom_conv
3209: FROM MTL_UOM_CONVERSIONS CON
3210: WHERE CON.UOM_CODE = l_hour_uom
3211: AND NVL(DISABLE_DATE, l_next_date) > l_sysdate
3212: AND CON.INVENTORY_ITEM_ID = l_inv_item_id;
3213: