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.ZX_TCM_EXT_SERVICES_PUB dependencies on MTL_ITEM_CATEGORIES

Line 263: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;

259: l_product_category_code VARCHAR2(240);
260: l_tax_event_class_code ZX_EVNT_CLS_MAPPINGS.TAX_EVENT_CLASS_CODE%TYPE;
261: l_owner_table ZX_FC_TYPES_B.OWNER_TABLE_CODE%TYPE;
262: l_owner_id_num ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE;
263: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
264: l_category_code varchar2(200);
265: l_product_type varchar2(200);
266: l_status varchar2(1);
267: l_db_status varchar2(1);

Line 323: FROM mtl_item_categories

319: WHERE classification_type_code ='INTENDED_USE';
320:
321: CURSOR c_item_category IS
322: SELECT category_id
323: FROM mtl_item_categories
324: WHERE category_set_id = l_owner_id_num
325: AND organization_id = p_org_id
326: AND inventory_item_id = p_item_id;
327:

Line 925: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;

921: */
922:
923: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;
924: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
925: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
926: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;
927: l_product_category_code VARCHAR2(240);
928: l_category_code varchar2(200);
929:

Line 947: FROM mtl_item_categories

943: WHERE country_code = p_country_code;
944:
945: CURSOR c_item_category IS
946: SELECT category_id
947: FROM mtl_item_categories
948: WHERE category_set_id = l_category_set
949: AND organization_id = p_org_id
950: AND inventory_item_id = p_item_id;
951: