[Home] [Help]
View: OE_AK_LINE_SCREDITS_V
View Text
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, TO_NUMBER(TO_CHAR(SALESREP_ID))
, SALES_CREDIT_ID
, SALES_CREDIT_TYPE_ID
, WH_UPDATE_DATE
, RPAD('X'
, 1
, '-')
, RPAD('T'
, 1
, '-')
, RPAD('X'
, 30
, '-')
, 1
FROM OE_SALES_CREDITS
Columns
Name |
ATTRIBUTE1 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
CONTEXT |
CREATED_BY |
CREATION_DATE |
DW_UPDATE_ADVICE_FLAG |
HEADER_ID |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
LINE_ID |
PERCENT |
SALESREP_ID |
SALES_CREDIT_ID |
SALES_CREDIT_TYPE_ID |
WH_UPDATE_DATE |
RETURN_STATUS |
DB_FLAG |
OPERATION |
LINE_INDEX |