eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_COMMON_PVT dependencies on MTL_MFG_PART_NUMBERS

Line 1024: FROM MTL_MFG_PART_NUMBERS_ALL_V

1020: CURSOR get_rec_from_value ( c_manufacturer_name VARCHAR2 )
1021: IS
1022: /*SELECT DISTINCT manufacturer_id,
1023: inventory_item_id
1024: FROM MTL_MFG_PART_NUMBERS_ALL_V
1025: WHERE manufacturer_name = c_manufacturer_name;*/
1026:
1027: --priyan
1028: --Changing the query for performance reasons

Line 1034: mtl_mfg_part_numbers a

1030:
1031: select distinct b.manufacturer_id,
1032: a.inventory_item_id
1033: from mtl_manufacturers b,
1034: mtl_mfg_part_numbers a
1035: where a.manufacturer_id = b.manufacturer_id
1036: and b.manufacturer_name = c_manufacturer_name
1037: and a.organization_id in ( select distinct
1038: m.master_organization_id

Line 1049: FROM MTL_MFG_PART_NUMBERS_ALL_V

1045: CURSOR get_rec_from_id ( c_manufacturer_id NUMBER )
1046: IS
1047: /*SELECT DISTINCT manufacturer_id,
1048: inventory_item_id
1049: FROM MTL_MFG_PART_NUMBERS_ALL_V
1050: WHERE manufacturer_id = c_manufacturer_id;*/
1051:
1052: --priyan
1053: --Changing the query for performance reasons

Line 1058: from mtl_mfg_part_numbers

1054: --Refer Bug # 5078530
1055:
1056: select distinct manufacturer_id,
1057: inventory_item_id
1058: from mtl_mfg_part_numbers
1059: where manufacturer_id = c_manufacturer_id
1060: and organization_id in ( select distinct
1061: m.master_organization_id
1062: from inv_organization_info_v org,