APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORY_SETS_VL

Line 660: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

656: l_structure_id mtl_category_sets_b.structure_id%TYPE;
657: l_category_status VARCHAR2(200);
658: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
659:
660: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
661: l_Item_id Number;
662: l_Item_organization_id Number;
663: l_record_type zx_Fc_types_b.record_type_code%type;
664: l_classification_name fnd_lookup_values.meaning%type;

Line 1081: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;

1077: WHERE Category_Set_Name ='WINE_CIGARRETE_CATEGORY';
1078:
1079: l_LANGUAGE zx_fc_types_tl.language%type;
1080: l_fc_id zx_fc_codes_b.classification_id%type;
1081: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1082: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1083: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1084: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1085: v_classification_code zx_fc_codes_b.classification_code%type;

Line 3693: FROM mtl_category_sets_vl

3689: If Zx_Migrate_Util.IS_INSTALLED('INV') = 'Y' THEN
3690:
3691: SELECT category_set_id
3692: Into l_category_set
3693: FROM mtl_category_sets_vl
3694: WHERE category_set_name ='INTENDED_USE';
3695:
3696: UPDATE ZX_FC_TYPES_B
3697: SET owner_table_code = 'MTL_CATEGORY_SETS_B',

Line 4799: SELECT category_set_name INTO x_category_set_name FROM MTL_CATEGORY_SETS_VL

4795:
4796: END IF;
4797:
4798: IF x_category_set is not null then
4799: SELECT category_set_name INTO x_category_set_name FROM MTL_CATEGORY_SETS_VL
4800: WHERE category_set_id = x_category_set and rownum = 1;
4801: END IF;
4802:
4803: -- Update the record type, created by and last updated by values

Line 4828: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

4824: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4825: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4826: l_category_status VARCHAR2(200);
4827: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4828: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4829: l_Item_id Number;
4830: l_Item_organization_id Number;
4831: l_record_type zx_Fc_types_b.record_type_code%type;
4832: l_classification_name fnd_lookup_values.meaning%type;