VIEW: APPS.RG_DSS_SYSTEM_SEG_ORDER_V

Source

View Text - Preformatted

SELECT SEGORDER.ROWID ROW_ID , SEGORDER.SYSTEM_ID SYSTEM_ID , SEGORDER.SEQUENCE SEQUENCE , FLEX.SEGMENT_NAME SEGMENT_NAME , SEGORDER.APPLICATION_COLUMN_NAME APPLICATION_COLUMN_NAME , SEGORDER.ID_FLEX_CODE ID_FLEX_CODE , SEGORDER.ID_FLEX_NUM ID_FLEX_NUM , SEGORDER.CREATION_DATE CREATION_DATE , SEGORDER.CREATED_BY CREATED_BY , SEGORDER.LAST_UPDATE_DATE LAST_UPDATE_DATE , SEGORDER.LAST_UPDATED_BY LAST_UPDATED_BY , SEGORDER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , SEGORDER.CONTEXT CONTEXT , SEGORDER.ATTRIBUTE1 ATTRIBUTE1 , SEGORDER.ATTRIBUTE2 ATTRIBUTE2 , SEGORDER.ATTRIBUTE3 ATTRIBUTE3 , SEGORDER.ATTRIBUTE4 ATTRIBUTE4 , SEGORDER.ATTRIBUTE5 ATTRIBUTE5 , SEGORDER.ATTRIBUTE6 ATTRIBUTE6 , SEGORDER.ATTRIBUTE7 ATTRIBUTE7 , SEGORDER.ATTRIBUTE8 ATTRIBUTE8 , SEGORDER.ATTRIBUTE9 ATTRIBUTE9 , SEGORDER.ATTRIBUTE10 ATTRIBUTE10 , SEGORDER.ATTRIBUTE11 ATTRIBUTE11 , SEGORDER.ATTRIBUTE12 ATTRIBUTE12 , SEGORDER.ATTRIBUTE13 ATTRIBUTE13 , SEGORDER.ATTRIBUTE14 ATTRIBUTE14 , SEGORDER.ATTRIBUTE15 ATTRIBUTE15 FROM RG_DSS_SYSTEM_SEG_ORDER SEGORDER, FND_ID_FLEX_SEGMENTS FLEX WHERE FLEX.APPLICATION_ID = DECODE(SEGORDER.SYSTEM_ID, NULL, 101, 101) AND FLEX.ID_FLEX_CODE = SEGORDER.ID_FLEX_CODE AND FLEX.ID_FLEX_NUM = SEGORDER.ID_FLEX_NUM AND FLEX.APPLICATION_COLUMN_NAME = SEGORDER.APPLICATION_COLUMN_NAME

View Text - HTML Formatted

SELECT SEGORDER.ROWID ROW_ID
, SEGORDER.SYSTEM_ID SYSTEM_ID
, SEGORDER.SEQUENCE SEQUENCE
, FLEX.SEGMENT_NAME SEGMENT_NAME
, SEGORDER.APPLICATION_COLUMN_NAME APPLICATION_COLUMN_NAME
, SEGORDER.ID_FLEX_CODE ID_FLEX_CODE
, SEGORDER.ID_FLEX_NUM ID_FLEX_NUM
, SEGORDER.CREATION_DATE CREATION_DATE
, SEGORDER.CREATED_BY CREATED_BY
, SEGORDER.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SEGORDER.LAST_UPDATED_BY LAST_UPDATED_BY
, SEGORDER.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SEGORDER.CONTEXT CONTEXT
, SEGORDER.ATTRIBUTE1 ATTRIBUTE1
, SEGORDER.ATTRIBUTE2 ATTRIBUTE2
, SEGORDER.ATTRIBUTE3 ATTRIBUTE3
, SEGORDER.ATTRIBUTE4 ATTRIBUTE4
, SEGORDER.ATTRIBUTE5 ATTRIBUTE5
, SEGORDER.ATTRIBUTE6 ATTRIBUTE6
, SEGORDER.ATTRIBUTE7 ATTRIBUTE7
, SEGORDER.ATTRIBUTE8 ATTRIBUTE8
, SEGORDER.ATTRIBUTE9 ATTRIBUTE9
, SEGORDER.ATTRIBUTE10 ATTRIBUTE10
, SEGORDER.ATTRIBUTE11 ATTRIBUTE11
, SEGORDER.ATTRIBUTE12 ATTRIBUTE12
, SEGORDER.ATTRIBUTE13 ATTRIBUTE13
, SEGORDER.ATTRIBUTE14 ATTRIBUTE14
, SEGORDER.ATTRIBUTE15 ATTRIBUTE15
FROM RG_DSS_SYSTEM_SEG_ORDER SEGORDER
, FND_ID_FLEX_SEGMENTS FLEX
WHERE FLEX.APPLICATION_ID = DECODE(SEGORDER.SYSTEM_ID
, NULL
, 101
, 101)
AND FLEX.ID_FLEX_CODE = SEGORDER.ID_FLEX_CODE
AND FLEX.ID_FLEX_NUM = SEGORDER.ID_FLEX_NUM
AND FLEX.APPLICATION_COLUMN_NAME = SEGORDER.APPLICATION_COLUMN_NAME