VIEW: APPS.RG_ROW_SEGMENT_SEQUENCES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'