APPS.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORY_SETS_VL

Line 644: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

640: l_structure_id mtl_category_sets_b.structure_id%TYPE;
641: l_category_status VARCHAR2(200);
642: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
643:
644: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
645: l_Item_id Number;
646: l_Item_organization_id Number;
647: l_record_type zx_Fc_types_b.record_type_code%type;
648:

Line 1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;

1072: WHERE Category_Set_Name ='WINE_CIGARRETE_CATEGORY';
1073:
1074: l_LANGUAGE zx_fc_types_tl.language%type;
1075: l_fc_id zx_fc_codes_b.classification_id%type;
1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1080: v_classification_code zx_fc_codes_b.classification_code%type;

Line 3494: FROM mtl_category_sets_vl

3490: If Zx_Migrate_Util.IS_INSTALLED('INV') = 'Y' THEN
3491:
3492: SELECT category_set_id
3493: Into l_category_set
3494: FROM mtl_category_sets_vl
3495: WHERE category_set_name ='INTENDED_USE';
3496:
3497: UPDATE ZX_FC_TYPES_B
3498: SET owner_table_code = 'MTL_CATEGORY_SETS_B',

Line 4575: SELECT category_set_name INTO x_category_set_name FROM MTL_CATEGORY_SETS_VL

4571:
4572: END IF;
4573:
4574: IF x_category_set is not null then
4575: SELECT category_set_name INTO x_category_set_name FROM MTL_CATEGORY_SETS_VL
4576: WHERE category_set_id = x_category_set and rownum = 1;
4577: END IF;
4578:
4579: -- Update the record type, created by and last updated by values

Line 4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

4600: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4601: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4602: l_category_status VARCHAR2(200);
4603: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4605: l_Item_id Number;
4606: l_Item_organization_id Number;
4607: l_record_type zx_Fc_types_b.record_type_code%type;
4608: l_classification_name fnd_lookup_values.meaning%type;