1056: x_progress := '004';
1057: BEGIN
1058: SELECT MIC.category_id
1059: INTO x_category_id
1060: FROM MTL_ITEM_CATEGORIES MIC,
1061: MTL_DEFAULT_SETS_VIEW MDSV
1062: WHERE MIC.inventory_item_id = x_item_id
1063: AND MIC.organization_id = x_inv_org_id
1064: AND MIC.category_set_id = MDSV.category_set_id
1096: x_progress := '005';
1097: BEGIN
1098: SELECT distinct 'Y'
1099: INTO x_valid_flag
1100: FROM MTL_ITEM_CATEGORIES MIC,
1101: MTL_DEFAULT_SETS_VIEW MDSV
1102: WHERE MIC.category_id = x_category_id
1103: AND MIC.inventory_item_id = x_item_id
1104: AND MIC.organization_id = x_inv_org_id