DBA Data[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on MFG_LOOKUPS

Line 825: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups

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

Line 988: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups

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