Product: | AS - Sales Foundation |
---|---|
Description: | Collateral view |
Implementation/DBA Data: | Not implemented in this database |
SELECT P.ROWID
, P.PROMOTION_ID
, P.CODE
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_LOGIN
, P.NAME
, P.TYPE
, P.ENABLED_FLAG
, P.OWNER_PERSON_ID
, P.PUBLIC_FLAG
, P.COUNTRY
, TERR.TERRITORY_SHORT_NAME
, DECODE(P.STATUS
, 'K'
, DECODE(P.PUBLIC_FLAG
, 'N'
, 'PERSONAL_KIT'
, 'PUBLIC_KIT')
, P.STATUS)
, LKUP1.MEANING
, P.LANGUAGE
, LKUP2.MEANING
, P.CURRENCY_CODE
, P.EXPECTED_PROMOTION_COST
, P.ACTUAL_PROMOTION_COST
, P.COLLATERAL_CHARGEBACK_AMT
, P.EXPECTED_NUM_OF_RESPONSES
, P.ACTUAL_NUM_OF_RESPONSES
, P.DESCRIPTION
, P.WORD_PROCESSOR_ID
, WP.WORD_PROCESSOR_NAME
, P.EXTERNAL_FILE_NAME
, P.COLLATERAL_QTY_ON_HAND
, P.COLLATERAL_INVENTORY_ITEM_ID
, P.COLLATERAL_ORGANIZATION_ID
, P.PRICE_LIST_ID
, SPL.NAME
, P.COLLATERAL_ONLINE_FLAG
, P.COLLATERAL_KIT_FLAG
, P.COLLATERAL_PICK_FLAG
, DECODE(P.COLLATERAL_INVENTORY_ITEM_ID
, NULL
, 'N'
, 'Y')
, DECODE(P.WORD_PROCESSOR_ID
, NULL
, 'N'
, 'Y')
, NVL(WP.PRINT_FLAG
, 'N')
, NVL(WP.FAX_FLAG
, 'N')
, NVL(WP.EMAIL_FLAG
, 'N')
, P.ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
FROM SO_PRICE_LISTS_VL SPL
, FND_TERRITORIES_TL TERR
, AS_LOOKUPS LKUP1
, AS_LOOKUPS LKUP2
, AS_WORD_PROCESSORS WP
, AS_PROMOTIONS P
WHERE P.TYPE = 'C'
AND P.WORD_PROCESSOR_ID = WP.WORD_PROCESSOR_ID(+)
AND DECODE(P.STATUS
, 'K'
, DECODE(P.PUBLIC_FLAG
, 'N'
, 'PERSONAL_KIT'
, 'PUBLIC_KIT')
, P.STATUS) = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'COLLATERAL_STATUS'
AND P.COUNTRY = TERR.TERRITORY_CODE(+)
AND TERR.LANGUAGE(+) = USERENV('LANG')
AND P.LANGUAGE = LKUP2.LOOKUP_CODE(+)
AND LKUP2.LOOKUP_TYPE(+) = 'LANGUAGE'
AND P.PRICE_LIST_ID = SPL.PRICE_LIST_ID(+)