VIEW: APPS.ENI_ITEM_CATEGORY_V

Source

View Text - Preformatted

SELECT ID, VALUE, TO_CHAR(PARENT_ID) PRODUCT_CATEGORY_ID from ENI_DENORM_HIERARCHIES A, ENI_OLTP_ITEM_STAR B where B.VBH_CATEGORY_ID = A.CHILD_ID and B.MASTER_ID is null union all select ID, VALUE, 'ALL' from ENI_OLTP_ITEM_STAR where MASTER_ID is null

View Text - HTML Formatted

SELECT ID
, VALUE
, TO_CHAR(PARENT_ID) PRODUCT_CATEGORY_ID
FROM ENI_DENORM_HIERARCHIES A
, ENI_OLTP_ITEM_STAR B
WHERE B.VBH_CATEGORY_ID = A.CHILD_ID
AND B.MASTER_ID IS NULL UNION ALL SELECT ID
, VALUE
, 'ALL'
FROM ENI_OLTP_ITEM_STAR
WHERE MASTER_ID IS NULL