APPS.AHL_FMP_MR_HEADER_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 639: FROM mtl_system_items_kfv

635: IS
636: --AMSRINIV. Bug 4916286. Removing 'upper' to improve performance.
637:
638: SELECT inventory_item_id
639: FROM mtl_system_items_kfv
640: WHERE STOCK_ENABLED_FLAG='N'
641: AND MTL_TRANSACTIONS_ENABLED_FLAG='N'
642: AND concatenated_segments= ltrim(rtrim(c_billing_item))
643: and rownum <2;

Line 646: FROM mtl_system_items_kfv

642: AND concatenated_segments= ltrim(rtrim(c_billing_item))
643: and rownum <2;
644:
645: /*SELECT inventory_item_id
646: FROM mtl_system_items_kfv
647: WHERE STOCK_ENABLED_FLAG='N'
648: AND MTL_TRANSACTIONS_ENABLED_FLAG='N'
649: AND upper(concatenated_segments)= upper(ltrim(rtrim(c_billing_item)))
650: and rownum <2;*/

Line 1073: mtl_system_items_kfv mtl

1069: mr.uom_code
1070: FROM
1071: ahl_mr_headers_b mr,
1072: qa_char_value_lookups qa,
1073: mtl_system_items_kfv mtl
1074: WHERE
1075: mr_header_id= c_mr_header_id AND
1076: qa.short_code(+) = mr.qa_inspection_type AND
1077: qa.char_id(+) = 87 AND