DBA Data[Home] [Help]

APPS.OE_ADV_PRICE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 200: FROM mtl_system_items_kfv

196: px_line_rec.ordered_item_id := p_related_item_id;
197: Begin
198: SELECT concatenated_segments
199: INTO px_line_rec.ordered_item
200: FROM mtl_system_items_kfv
201: WHERE inventory_item_id = px_line_rec.inventory_item_id
202: AND organization_id = l_org_id;
203: Exception when no_data_found then
204: Null;

Line 1125: FROM mtl_system_items_kfv

1121: Begin
1122:
1123: SELECT concatenated_segments
1124: INTO l_line_rec.ordered_item
1125: FROM mtl_system_items_kfv
1126: WHERE inventory_item_id = l_line_rec.inventory_item_id
1127: AND organization_id = l_org_id;
1128: Exception when no_data_found then
1129: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRG_INVALID_MASTER_ORG');