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 963: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;

959: */
960:
961: l_country_code FND_TERRITORIES.TERRITORY_CODE%TYPE;
962: l_category_set ZX_FC_COUNTRY_DEFAULTS.PRIMARY_INVENTORY_CATEGORY_SET%TYPE;
963: l_category_id MTL_ITEM_CATEGORIES.CATEGORY_ID%TYPE;
964: l_intended_use ZX_FC_COUNTRY_DEFAULTS.INTENDED_USE_DEFAULT%TYPE;
965: l_product_category_code VARCHAR2(240);
966: l_category_code varchar2(200);
967:

Line 985: FROM mtl_item_categories

981: WHERE country_code = p_country_code;
982:
983: CURSOR c_item_category IS
984: SELECT category_id
985: FROM mtl_item_categories
986: WHERE category_set_id = l_category_set
987: AND organization_id = p_org_id
988: AND inventory_item_id = p_item_id;
989: