VIEW: APPS.QP_ITEM_CATEGORIES_V

Source

View Text - Preformatted

SELECT distinct a.category_id CATEGORY_ID, k.concatenated_segments CATEGORY_NAME, a.category_desc CATEGORY_DESC, a.DISABLE_DATE, a.CATEGORY_SET_ID, b.functional_area_id FUNCTIONAL_AREA_ID FROM eni_prod_den_hrchy_parents_v a, mtl_default_category_sets b, mtl_categories_kfv k WHERE b.functional_area_id = 11 AND NVL(a.DISABLE_DATE,SYSDATE+1) > SYSDATE AND a.category_set_id = b.category_set_id AND 'I' = (select status from fnd_product_installations where application_id = 661) AND k.category_id=a.category_id UNION SELECT distinct c.category_id CATEGORY_ID, c.concatenated_segments CATEGORY_NAME, nvl(e.description, substr(c.concatenated_segments, instr(c.concatenated_segments, d.concatenated_segment_delimiter, -1)+1)) CATEGORY_DESC, e.DISABLE_DATE, a.CATEGORY_SET_ID, a.functional_area_id FROM mtl_default_category_sets a, mtl_category_sets b, mtl_categories_kfv c, fnd_id_flex_structures d, mtl_categories_vl e WHERE a.functional_area_id <> 11 AND a.category_set_id = b.category_set_id AND NVL(e.DISABLE_DATE,SYSDATE+1) > SYSDATE AND b.structure_id = c.structure_id AND b.structure_id = d.id_flex_num AND c.category_id = e.category_id AND d.id_flex_code = 'MCAT' AND ('Y' <> nvl(b.hierarchy_enabled, 'N') OR 'I' = (select status from fnd_product_installations where application_id = 661))

View Text - HTML Formatted

SELECT DISTINCT A.CATEGORY_ID CATEGORY_ID
, K.CONCATENATED_SEGMENTS CATEGORY_NAME
, A.CATEGORY_DESC CATEGORY_DESC
, A.DISABLE_DATE
, A.CATEGORY_SET_ID
, B.FUNCTIONAL_AREA_ID FUNCTIONAL_AREA_ID
FROM ENI_PROD_DEN_HRCHY_PARENTS_V A
, MTL_DEFAULT_CATEGORY_SETS B
, MTL_CATEGORIES_KFV K
WHERE B.FUNCTIONAL_AREA_ID = 11
AND NVL(A.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID
AND 'I' = (SELECT STATUS
FROM FND_PRODUCT_INSTALLATIONS
WHERE APPLICATION_ID = 661)
AND K.CATEGORY_ID=A.CATEGORY_ID UNION SELECT DISTINCT C.CATEGORY_ID CATEGORY_ID
, C.CONCATENATED_SEGMENTS CATEGORY_NAME
, NVL(E.DESCRIPTION
, SUBSTR(C.CONCATENATED_SEGMENTS
, INSTR(C.CONCATENATED_SEGMENTS
, D.CONCATENATED_SEGMENT_DELIMITER
, -1)+1)) CATEGORY_DESC
, E.DISABLE_DATE
, A.CATEGORY_SET_ID
, A.FUNCTIONAL_AREA_ID
FROM MTL_DEFAULT_CATEGORY_SETS A
, MTL_CATEGORY_SETS B
, MTL_CATEGORIES_KFV C
, FND_ID_FLEX_STRUCTURES D
, MTL_CATEGORIES_VL E
WHERE A.FUNCTIONAL_AREA_ID <> 11
AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID
AND NVL(E.DISABLE_DATE
, SYSDATE+1) > SYSDATE
AND B.STRUCTURE_ID = C.STRUCTURE_ID
AND B.STRUCTURE_ID = D.ID_FLEX_NUM
AND C.CATEGORY_ID = E.CATEGORY_ID
AND D.ID_FLEX_CODE = 'MCAT'
AND ('Y' <> NVL(B.HIERARCHY_ENABLED
, 'N') OR 'I' = (SELECT STATUS
FROM FND_PRODUCT_INSTALLATIONS
WHERE APPLICATION_ID = 661))