APPS.OE_ADV_PRICE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 221: FROM mtl_system_items_kfv

217: px_line_rec.ordered_item_id := p_related_item_id;
218: Begin
219: SELECT concatenated_segments
220: INTO px_line_rec.ordered_item
221: FROM mtl_system_items_kfv
222: WHERE inventory_item_id = px_line_rec.inventory_item_id
223: AND organization_id = l_org_id;
224: Exception when no_data_found then
225: Null;

Line 1422: FROM mtl_system_items_kfv

1418: Begin
1419:
1420: SELECT concatenated_segments
1421: INTO l_line_rec.ordered_item
1422: FROM mtl_system_items_kfv
1423: WHERE inventory_item_id = l_line_rec.inventory_item_id
1424: AND organization_id = l_org_id;
1425: Exception when no_data_found then
1426: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');

Line 1853: FROM MTL_SYSTEM_ITEMS

1849: BEGIN
1850: -- checking if it is service item which needs to be referenced
1851: SELECT SERVICE_ITEM_FLAG,CONTRACT_ITEM_TYPE_CODE
1852: INTO l_service_item_flag,l_contract_item_type_code
1853: FROM MTL_SYSTEM_ITEMS
1854: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
1855: AND ORGANIZATION_ID = l_org_id;
1856: oe_debug_pub.ADD(' l_service_item_flag:- '||l_service_item_flag,1);
1857: oe_debug_pub.ADD(' l_contract_item_type_code:- '||l_contract_item_type_code,1);