DBA Data[Home] [Help]

APPS.DPP_LISTPRICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 80: mtl_system_items_kfv msi

76: SELECT DECODE( p_control_level, 1, mp.master_organization_id, 2, mp.organization_id) organization_id,
77: msi.concatenated_segments item_number
78: FROM mtl_parameters mp,
79: financials_system_params_all fspa,
80: mtl_system_items_kfv msi
81: WHERE mp.organization_id = fspa.inventory_organization_id and
82: mp.organization_id = msi.organization_id and
83: msi.inventory_item_id = p_inventory_item_id and
84: fspa.org_id = p_org_id;

Line 239: FROM mtl_system_items_kfv

235: FROM dual;
236:
237: SELECT DISTINCT(concatenated_segments)
238: INTO l_item_number
239: FROM mtl_system_items_kfv
240: WHERE inventory_item_id = l_item_cost_tbl(i).inventory_item_id;
241:
242: INSERT INTO DPP_OUTPUT_XML_GT(Item_Number,
243: NewPrice,