Product: | AMS - Marketing |
---|---|
Description: | Table for storing various costs for Customer |
Implementation/DBA Data: | Not implemented in this database |
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')