DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on MTL_CATEGORY_SETS_V

Line 3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;

3521: l_index NUMBER;
3522: i NUMBER;
3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3524:
3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;
3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:
3528: l_category_name MTL_CATEGORIES_B_KFV.concatenated_segments%TYPE;
3529:

Line 3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;

3522: i NUMBER;
3523: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
3524:
3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;
3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:
3528: l_category_name MTL_CATEGORIES_B_KFV.concatenated_segments%TYPE;
3529:
3530: l_ip_category_name ICX_CAT_CATEGORIES_V.category_name%TYPE;

Line 3602: FROM MTL_CATEGORY_SETS_V

3598: -- Find out the default category_set_id and validate_flag for function_area
3599: -- of PURCHASING".
3600: SELECT validate_flag, category_set_id
3601: INTO l_validate_flag, l_category_set_id
3602: FROM MTL_CATEGORY_SETS_V
3603: WHERE category_set_id =
3604: (SELECT category_set_id
3605: FROM MTL_DEFAULT_CATEGORY_SETS
3606: WHERE functional_area_id = 2) ; -- Purchasing