VIEW: APPS.ENI_PROD_DENORM_HRCHY_V

Source

View Text - Preformatted

SELECT a.OBJECT_ID CATEGORY_SET_ID, a.PARENT_ID, a.IMM_CHILD_ID, a.CHILD_ID, a.TOP_NODE_FLAG, a.LEAF_NODE_FLAG, a.OLTP_FLAG, a.DBI_FLAG, a.CREATION_DATE, a.LAST_UPDATE_DATE FROM ENI_DENORM_HIERARCHIES a, MTL_DEFAULT_CATEGORY_SETS b WHERE b.FUNCTIONAL_AREA_ID = 11 AND b.CATEGORY_SET_ID = a.OBJECT_ID AND a.OBJECT_TYPE = 'CATEGORY_SET'

View Text - HTML Formatted

SELECT A.OBJECT_ID CATEGORY_SET_ID
, A.PARENT_ID
, A.IMM_CHILD_ID
, A.CHILD_ID
, A.TOP_NODE_FLAG
, A.LEAF_NODE_FLAG
, A.OLTP_FLAG
, A.DBI_FLAG
, A.CREATION_DATE
, A.LAST_UPDATE_DATE
FROM ENI_DENORM_HIERARCHIES A
, MTL_DEFAULT_CATEGORY_SETS B
WHERE B.FUNCTIONAL_AREA_ID = 11
AND B.CATEGORY_SET_ID = A.OBJECT_ID
AND A.OBJECT_TYPE = 'CATEGORY_SET'