Product: | AS - Sales Foundation |
---|---|
Description: | Collateral request items |
Implementation/DBA Data: | Not implemented in this database |
SELECT ITM.ROWID
, ITM.COLLATERAL_REQ_ITEM_ID
, ITM.LAST_UPDATE_DATE
, ITM.LAST_UPDATED_BY
, ITM.CREATION_DATE
, ITM.CREATED_BY
, ITM.LAST_UPDATE_LOGIN
, ITM.COLLATERAL_ID
, P.CODE
, P.NAME
, ASLKP.MEANING
, P.COLLATERAL_KIT_FLAG
, P.COLLATERAL_CHARGEBACK_AMT
, P.DESCRIPTION
, ITM.COLLATERAL_REQUEST_ID
, ITM.INVENTORY_ITEM_ID
, ITM.ORGANIZATION_ID
, ITM.QUANTITY
, ITM.ATTRIBUTE_CATEGORY
, ITM.ATTRIBUTE1
, ITM.ATTRIBUTE2
, ITM.ATTRIBUTE3
, ITM.ATTRIBUTE4
, ITM.ATTRIBUTE5
, ITM.ATTRIBUTE6
, ITM.ATTRIBUTE7
, ITM.ATTRIBUTE8
, ITM.ATTRIBUTE9
, ITM.ATTRIBUTE10
, ITM.ATTRIBUTE11
, ITM.ATTRIBUTE12
, ITM.ATTRIBUTE13
, ITM.ATTRIBUTE14
, ITM.ATTRIBUTE15
FROM AS_LOOKUPS ASLKP
, AS_PROMOTIONS P
, AS_COLLATERAL_REQ_ITEMS ITM
WHERE DECODE(P.STATUS
, 'K'
, DECODE(P.PUBLIC_FLAG
, 'N'
, 'PERSONAL_KIT'
, 'PUBLIC_KIT')
, P.STATUS) = ASLKP.LOOKUP_CODE
AND ASLKP.LOOKUP_TYPE = 'COLLATERAL_STATUS'
AND ITM.COLLATERAL_ID = P.PROMOTION_ID(+)