VIEW: APPS.AS_OPP_CLASSIFICATION_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'