APPS.AHL_FMP_MR_HEADER_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 692: FROM mtl_system_items_kfv

688: IS
689: --AMSRINIV. Bug 4916286. Removing 'upper' to improve performance.
690:
691: SELECT inventory_item_id
692: FROM mtl_system_items_kfv
693: WHERE STOCK_ENABLED_FLAG='N'
694: AND MTL_TRANSACTIONS_ENABLED_FLAG='N'
695: AND concatenated_segments= ltrim(rtrim(c_billing_item))
696: and rownum <2;

Line 709: FROM mtl_system_items_kfv

705: and rownum <2;
706: --CHANDANK changes ends for supplier warranty
707:
708: /*SELECT inventory_item_id
709: FROM mtl_system_items_kfv
710: WHERE STOCK_ENABLED_FLAG='N'
711: AND MTL_TRANSACTIONS_ENABLED_FLAG='N'
712: AND upper(concatenated_segments)= upper(ltrim(rtrim(c_billing_item)))
713: and rownum <2;*/

Line 1203: mtl_system_items_kfv mtl

1199: mr.uom_code
1200: FROM
1201: ahl_mr_headers_b mr,
1202: qa_char_value_lookups qa,
1203: mtl_system_items_kfv mtl
1204: WHERE
1205: mr_header_id= c_mr_header_id AND
1206: qa.short_code(+) = mr.qa_inspection_type AND
1207: qa.char_id(+) = 87 AND