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.

[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on MFG_LOOKUPS

Line 826: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups

822: SELECT B.STRUCTURE_ID
823: INTO l_structure_id
824: FROM MTL_DEFAULT_CATEGORY_SETS A,
825: MTL_CATEGORY_SETS_B B
826: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups
827: where lookup_type = 'MTL_FUNCTIONAL_AREAS' and upper(meaning) = upper(x_upload_to_functional_area))
828: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
829: ELSE
830: SELECT ID_FLEX_NUM

Line 989: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups

985: SELECT A.CATEGORY_SET_ID, B.STRUCTURE_ID
986: INTO l_category_set_id, l_structure_id
987: FROM MTL_DEFAULT_CATEGORY_SETS A,
988: MTL_CATEGORY_SETS B
989: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups
990: where lookup_type = 'MTL_FUNCTIONAL_AREAS'
991: and upper(meaning) = upper(x_upload_to_functional_area))
992: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
993: ELSE