Product: | AS - Sales Foundation |
---|---|
Description: | Sales opportunity classifications view |
Implementation/DBA Data: | APPS.AS_OPP_CLASSIFICATION_V |
SELECT INT.ROWID
, INT.INTEREST_ID
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATED_BY
, INT.CREATION_DATE
, INT.CREATED_BY
, INT.LAST_UPDATE_LOGIN
, INT.REQUEST_ID
, INT.PROGRAM_APPLICATION_ID
, INT.PROGRAM_ID
, INT.PROGRAM_UPDATE_DATE
, INT.INTEREST_TYPE_ID
, INT.INTEREST_USE_CODE
, INT.CUSTOMER_ID
, INT.ADDRESS_ID
, INT.CONTACT_ID
, INT.PRIMARY_INTEREST_CODE_ID
, INT.SECONDARY_INTEREST_CODE_ID
, INT.STATUS_CODE
, INT.DESCRIPTION
, INT.LEAD_ID
, INT.ATTRIBUTE_CATEGORY
, INT.ATTRIBUTE1
, INT.ATTRIBUTE2
, INT.ATTRIBUTE3
, INT.ATTRIBUTE4
, INT.ATTRIBUTE5
, INT.ATTRIBUTE6
, INT.ATTRIBUTE7
, INT.ATTRIBUTE8
, INT.ATTRIBUTE9
, INT.ATTRIBUTE10
, INT.ATTRIBUTE11
, INT.ATTRIBUTE12
, INT.ATTRIBUTE13
, INT.ATTRIBUTE14
, INT.ATTRIBUTE15
, INTTYPE.INTEREST_TYPE
, PIC.CODE
, SIC.CODE
, LO.MEANING
FROM AS_INTEREST_CODES_VL SIC
, AS_INTEREST_CODES_VL PIC
, AS_INTEREST_TYPES_VL INTTYPE
, AS_LOOKUPS LO
, AS_INTERESTS INT
WHERE INT.STATUS_CODE = LO.LOOKUP_CODE(+)
AND LO.LOOKUP_TYPE(+) = 'INTEREST_STATUS'
AND INT.SECONDARY_INTEREST_CODE_ID = SIC.INTEREST_CODE_ID(+)
AND INT.PRIMARY_INTEREST_CODE_ID = PIC.INTEREST_CODE_ID(+)
AND INT.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID(+)
AND INT.INTEREST_USE_CODE = 'LEAD_CLASSIFICATION'