APPS.OE_ORDER_ADJ_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 5469: FROM mtl_system_items_kfv

5465: px_line_rec.ordered_item_id := p_req_line_detail_rec.RELATED_ITEM_ID;
5466: Begin
5467: SELECT concatenated_segments
5468: INTO px_line_rec.ordered_item
5469: FROM mtl_system_items_kfv
5470: WHERE inventory_item_id = px_line_rec.inventory_item_id
5471: AND organization_id = l_org_id;
5472: Exception when no_data_found then
5473: Null;

Line 5502: FROM mtl_system_items_kfv

5498: px_line_rec.ordered_item_id := to_number(Adj_rec.modified_from);
5499: Begin
5500: SELECT concatenated_segments
5501: INTO px_line_rec.ordered_item
5502: FROM mtl_system_items_kfv
5503: WHERE inventory_item_id = px_line_rec.inventory_item_id
5504: AND organization_id = l_org_id;
5505: Exception when no_data_found then
5506: Null;

Line 7639: FROM mtl_system_items_kfv

7635: G_STMT_NO := 'Process_Other_Item_Line#140';
7636: Begin
7637: SELECT concatenated_segments
7638: INTO l_line_rec.ordered_item
7639: FROM mtl_system_items_kfv
7640: WHERE inventory_item_id = l_line_rec.inventory_item_id
7641: AND organization_id = l_org_id;
7642: Exception when no_data_found then
7643: Null;

Line 7920: FROM mtl_system_items_kfv

7916: If p_gsa_violation_action = 'WARNING' then
7917: Begin
7918: SELECT concatenated_segments
7919: INTO l_msg_text
7920: FROM mtl_system_items_kfv
7921: WHERE inventory_item_id = p_inventory_item_id
7922: AND organization_id = l_org_id;
7923: Exception when no_data_found then
7924: Null;