Product: | AS - Sales Foundation |
---|---|
Description: | Collateral kits |
Implementation/DBA Data: | Not implemented in this database |
SELECT K.ROWID
, K.PARENT_COLLATERAL_ID
, K.CHILD_COLLATERAL_ID
, C.CODE
, C.NAME
, C.STATUS
, C.DESCRIPTION
, C.CHARGEBACK_AMT
, C.QTY_ON_HAND
, DECODE(WP.WORD_PROCESSOR_ID
, NULL
, 'N'
, 'Y') MANUAL_PRINT_FLAG
, NVL(WP.PRINT_FLAG
, 'N') AUTO_PRINT_FLAG
, C.PICK_FLAG
, NVL(WP.FAX_FLAG
, 'N') FAX_FLAG
, NVL(WP.EMAIL_FLAG
, 'N') EMAIL_FLAG
, C.ONLINE_FLAG
, C.LANGUAGE
, C.COUNTRY
, C.INVENTORY_ITEM_ID
, C.ORGANIZATION_ID
, K.LAST_UPDATE_DATE
, K.LAST_UPDATED_BY
, K.CREATION_DATE
, K.CREATED_BY
, K.LAST_UPDATE_LOGIN
, K.QUANTITY
, K.ATTRIBUTE_CATEGORY
, K.ATTRIBUTE1
, K.ATTRIBUTE2
, K.ATTRIBUTE3
, K.ATTRIBUTE4
, K.ATTRIBUTE5
, K.ATTRIBUTE6
, K.ATTRIBUTE7
, K.ATTRIBUTE8
, K.ATTRIBUTE9
, K.ATTRIBUTE10
, K.ATTRIBUTE11
, K.ATTRIBUTE12
, K.ATTRIBUTE13
, K.ATTRIBUTE14
, K.ATTRIBUTE15
FROM AS_WORD_PROCESSORS WP
, AS_COLLATERAL_KITS K
, AS_COLLATERAL_V C
WHERE K.CHILD_COLLATERAL_ID = C.COLLATERAL_ID
AND C.WORD_PROCESSOR_ID = WP.WORD_PROCESSOR_ID(+)