VIEW: APPS.RG_DSS_HIERARCHY_DETAILS_V

Source

View Text - Preformatted

SELECT HRD.ROWID ROW_ID , HRD.HIERARCHY_ID , HRD.SEQUENCE , HRD.APPLICATION_COLUMN_NAME , HRC.ID_FLEX_CODE , HRC.ID_FLEX_NUM , FLX.SEGMENT_NAME , FLX.SEGMENT_NUM , HRD.ROOT_NODE , HRD.LAST_UPDATE_DATE , HRD.LAST_UPDATED_BY , HRD.LAST_UPDATE_LOGIN , HRD.CREATION_DATE , HRD.CREATED_BY , HRD.CONTEXT , HRD.ATTRIBUTE1 , HRD.ATTRIBUTE2 , HRD.ATTRIBUTE3 , HRD.ATTRIBUTE4 , HRD.ATTRIBUTE5 , HRD.ATTRIBUTE6 , HRD.ATTRIBUTE7 , HRD.ATTRIBUTE8 , HRD.ATTRIBUTE9 , HRD.ATTRIBUTE10 , HRD.ATTRIBUTE11 , HRD.ATTRIBUTE12 , HRD.ATTRIBUTE13 , HRD.ATTRIBUTE14 , HRD.ATTRIBUTE15 FROM RG_DSS_HIERARCHY_DETAILS HRD,RG_DSS_HIERARCHIES HRC,FND_ID_FLEX_SEGMENTS FLX WHERE HRD.APPLICATION_COLUMN_NAME = FLX.APPLICATION_COLUMN_NAME AND HRC.ID_FLEX_CODE = FLX.ID_FLEX_CODE AND HRC.ID_FLEX_NUM = FLX.ID_FLEX_NUM AND HRD.HIERARCHY_ID = HRC.HIERARCHY_ID

View Text - HTML Formatted

SELECT HRD.ROWID ROW_ID
, HRD.HIERARCHY_ID
, HRD.SEQUENCE
, HRD.APPLICATION_COLUMN_NAME
, HRC.ID_FLEX_CODE
, HRC.ID_FLEX_NUM
, FLX.SEGMENT_NAME
, FLX.SEGMENT_NUM
, HRD.ROOT_NODE
, HRD.LAST_UPDATE_DATE
, HRD.LAST_UPDATED_BY
, HRD.LAST_UPDATE_LOGIN
, HRD.CREATION_DATE
, HRD.CREATED_BY
, HRD.CONTEXT
, HRD.ATTRIBUTE1
, HRD.ATTRIBUTE2
, HRD.ATTRIBUTE3
, HRD.ATTRIBUTE4
, HRD.ATTRIBUTE5
, HRD.ATTRIBUTE6
, HRD.ATTRIBUTE7
, HRD.ATTRIBUTE8
, HRD.ATTRIBUTE9
, HRD.ATTRIBUTE10
, HRD.ATTRIBUTE11
, HRD.ATTRIBUTE12
, HRD.ATTRIBUTE13
, HRD.ATTRIBUTE14
, HRD.ATTRIBUTE15
FROM RG_DSS_HIERARCHY_DETAILS HRD
, RG_DSS_HIERARCHIES HRC
, FND_ID_FLEX_SEGMENTS FLX
WHERE HRD.APPLICATION_COLUMN_NAME = FLX.APPLICATION_COLUMN_NAME
AND HRC.ID_FLEX_CODE = FLX.ID_FLEX_CODE
AND HRC.ID_FLEX_NUM = FLX.ID_FLEX_NUM
AND HRD.HIERARCHY_ID = HRC.HIERARCHY_ID