FND Design Data [Home] [Help]

View: AMS_MISC_COST_DIS_VL

Product: AMS - Marketing
Description: Table for storing various costs for Customer
Implementation/DBA Data: Not implemented in this database
View Text

SELECT A.COST_DISC_ID
, A.FORECAST_ID
, A.PROD_SPREAD_ID
, A.CREATED_BY
, A.CREATION_DATE
, A.CREATED_FROM
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.REQUEST_ID
, A.OBJECT_VERSION_NUMBER
, A.OWNER_FLAG
, A.COST_DISCOUNT_FLAG
, A.COST_TYPE
, B.SHORT_NAME
, B.DESCRIPTION
, A.AMOUNT
, A.ACCTD_AMOUNT
, A.CURRENCY_CODE
, A.EXCHANGE_RATE_TYPE
, A.EXCHANGE_RATE_DATE
, A.EXCHANGE_RATE
, A.CONTEXT
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM AMS_MISC_COST_DIS_ALL_B A
, AMS_MISC_COST_DIS_ALL_TL B
WHERE A.COST_DISC_ID=B.COST_DISC_ID
AND NVL(A.ORG_ID
, -99) = NVL(B.ORG_ID
, -99)
AND NVL(A.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO' )
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND B.LANGUAGE = USERENV('LANG')

Columns

Name
COST_DISC_ID
FORECAST_ID
PROD_SPREAD_ID
CREATED_BY
CREATION_DATE
CREATED_FROM
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
OBJECT_VERSION_NUMBER
OWNER_FLAG
COST_DISCOUNT_FLAG
TYPE
SHORT_NAME
DESCRIPTION
AMOUNT
ACCTD_AMOUNT
CURRENCY_CODE
EXCHANGE_RATE_TYPE
EXCHANGE_RATE_DATE
EXCHANGE_RATE
CONTEXT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15