Product: | RG - Application Report Generator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RG_ROW_SEGMENT_SEQUENCES_V |
SELECT RS.ROWID ROW_ID
, RS.APPLICATION_ID
, RS.ROW_ORDER_ID
, RS.ROW_SEGMENT_SEQUENCE_ID
, RS.SEGMENT_SEQUENCE
, RS.SEG_ORDER_TYPE
, RS.SEG_DISPLAY_TYPE
, RS.STRUCTURE_ID
, RS.SEGMENT_NAME
, FX.SEGMENT_NAME SEG_NAME
, RS.APPLICATION_COLUMN_NAME
, RS.SEGMENT_WIDTH
, RS.CREATION_DATE
, RS.CREATED_BY
, RS.LAST_UPDATE_DATE
, RS.LAST_UPDATED_BY
, RS.LAST_UPDATE_LOGIN
, RS.CONTEXT
, RS.ATTRIBUTE1
, RS.ATTRIBUTE2
, RS.ATTRIBUTE3
, RS.ATTRIBUTE4
, RS.ATTRIBUTE5
, RS.ATTRIBUTE6
, RS.ATTRIBUTE7
, RS.ATTRIBUTE8
, RS.ATTRIBUTE9
, RS.ATTRIBUTE10
, RS.ATTRIBUTE11
, RS.ATTRIBUTE12
, RS.ATTRIBUTE13
, RS.ATTRIBUTE14
, RS.ATTRIBUTE15
FROM RG_ROW_SEGMENT_SEQUENCES RS
, RG_ROW_ORDERS RO
, FND_ID_FLEX_SEGMENTS FX
WHERE RO.ROW_ORDER_ID = RS.ROW_ORDER_ID
AND FX.ID_FLEX_CODE(+) = RO.ID_FLEX_CODE
AND FX.ID_FLEX_NUM(+) = RO.STRUCTURE_ID
AND FX.APPLICATION_COLUMN_NAME = RS.APPLICATION_COLUMN_NAME
AND FX.ENABLED_FLAG = 'Y'