DBA Data[Home] [Help]

APPS.DPP_LISTPRICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 81: mtl_system_items_kfv msi

77: SELECT DECODE( p_control_level, 1, mp.master_organization_id, 2, mp.organization_id) organization_id,
78: msi.concatenated_segments item_number
79: FROM mtl_parameters mp,
80: financials_system_params_all fspa,
81: mtl_system_items_kfv msi
82: WHERE mp.organization_id = fspa.inventory_organization_id and
83: mp.organization_id = msi.organization_id and
84: msi.inventory_item_id = p_inventory_item_id and
85: 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,