Product: | RG - Application Report Generator |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.RG_DSS_HIERARCHY_DETAILS_V |
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