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