DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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');