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 1013: FROM MTL_MFG_PART_NUMBERS_ALL_V

1009: CURSOR get_rec_from_value ( c_manufacturer_name VARCHAR2 )
1010: IS
1011: /*SELECT DISTINCT manufacturer_id,
1012: inventory_item_id
1013: FROM MTL_MFG_PART_NUMBERS_ALL_V
1014: WHERE manufacturer_name = c_manufacturer_name;*/
1015:
1016: --priyan
1017: --Changing the query for performance reasons

Line 1023: mtl_mfg_part_numbers a

1019:
1020: select distinct b.manufacturer_id,
1021: a.inventory_item_id
1022: from mtl_manufacturers b,
1023: mtl_mfg_part_numbers a
1024: where a.manufacturer_id = b.manufacturer_id
1025: and b.manufacturer_name = c_manufacturer_name
1026: and a.organization_id in ( select distinct
1027: m.master_organization_id

Line 1038: FROM MTL_MFG_PART_NUMBERS_ALL_V

1034: CURSOR get_rec_from_id ( c_manufacturer_id NUMBER )
1035: IS
1036: /*SELECT DISTINCT manufacturer_id,
1037: inventory_item_id
1038: FROM MTL_MFG_PART_NUMBERS_ALL_V
1039: WHERE manufacturer_id = c_manufacturer_id;*/
1040:
1041: --priyan
1042: --Changing the query for performance reasons

Line 1047: from mtl_mfg_part_numbers

1043: --Refer Bug # 5078530
1044:
1045: select distinct manufacturer_id,
1046: inventory_item_id
1047: from mtl_mfg_part_numbers
1048: where manufacturer_id = c_manufacturer_id
1049: and organization_id in ( select distinct
1050: m.master_organization_id
1051: from inv_organization_info_v org,