DBA Data[Home] [Help]

APPS.CSTPCOIC dependencies on MTL_SYSTEM_ITEMS_KFV

Line 85: FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic

81: INSERT INTO CST_UOM_CONV_RATES_TEMP (INVENTORY_ITEM_ID, UOM_CONVERSION_RATE, ITEM_NAME)
82: SELECT src.inventory_item_id,
83: inv_convert.inv_um_convert(src.inventory_item_id, 30, NULL, src.primary_uom_code, dst.primary_uom_code, NULL, NULL),
84: substr(src.concatenated_segments,1,50)
85: FROM mtl_system_items_kfv src, mtl_system_items_b dst, cst_item_costs cic
86: WHERE cic.cost_type_id = from_cst_type_id
87: AND (
88: /* -- ALL ITEMS -- */
89: (range_option = 1)