APPS.OE_ORDER_ADJ_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 5552: FROM mtl_system_items_kfv

5548: px_line_rec.ordered_item_id := p_req_line_detail_rec.RELATED_ITEM_ID;
5549: Begin
5550: SELECT concatenated_segments
5551: INTO px_line_rec.ordered_item
5552: FROM mtl_system_items_kfv
5553: WHERE inventory_item_id = px_line_rec.inventory_item_id
5554: AND organization_id = l_org_id;
5555: Exception when no_data_found then
5556: Null;

Line 5585: FROM mtl_system_items_kfv

5581: px_line_rec.ordered_item_id := to_number(Adj_rec.modified_from);
5582: Begin
5583: SELECT concatenated_segments
5584: INTO px_line_rec.ordered_item
5585: FROM mtl_system_items_kfv
5586: WHERE inventory_item_id = px_line_rec.inventory_item_id
5587: AND organization_id = l_org_id;
5588: Exception when no_data_found then
5589: Null;

Line 7731: FROM mtl_system_items_kfv

7727: G_STMT_NO := 'Process_Other_Item_Line#140';
7728: Begin
7729: SELECT concatenated_segments
7730: INTO l_line_rec.ordered_item
7731: FROM mtl_system_items_kfv
7732: WHERE inventory_item_id = l_line_rec.inventory_item_id
7733: AND organization_id = l_org_id;
7734: Exception when no_data_found then
7735: Null;

Line 8012: FROM mtl_system_items_kfv

8008: If p_gsa_violation_action = 'WARNING' then
8009: Begin
8010: SELECT concatenated_segments
8011: INTO l_msg_text
8012: FROM mtl_system_items_kfv
8013: WHERE inventory_item_id = p_inventory_item_id
8014: AND organization_id = l_org_id;
8015: Exception when no_data_found then
8016: Null;