DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 443: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI, MTL_UNITS_OF_MEASURE UOM

439:
440: CURSOR get_part_info(c_instance_id NUMBER) IS
441: SELECT MTL.inventory_item_id, MTL.concatenated_segments, CSI.instance_number, CSI.serial_number, CSI.quantity,
442: CSI.lot_number, UOM.unit_of_measure, CSI.object_version_number
443: FROM MTL_SYSTEM_ITEMS_VL MTL, CSI_ITEM_INSTANCES CSI, MTL_UNITS_OF_MEASURE UOM
444: WHERE CSI.instance_id = c_instance_id
445: AND CSI.inventory_item_id = MTL.inventory_item_id
446: AND CSI.inv_master_organization_id = MTL.organization_id
447: AND CSI.unit_of_measure = UOM.uom_code;