[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Product interest answer actions view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AA.ROWID
, AA.SCRIPT_ANSWER_ACTION_ID
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATED_BY
, AA.CREATION_DATE
, AA.CREATED_BY
, AA.PRE_DEF_ANSWER_ID
, AA.INTEREST_TYPE_ID
, INTTYPE.INTEREST_TYPE
, AA.PRIMARY_INTEREST_CODE_ID
, INTC1.CODE
, AA.SECONDARY_INTEREST_CODE_ID
, INTC2.CODE
, AA.INTEREST_STATUS_CODE
, ASLKP1.MEANING
FROM AS_INTEREST_TYPES_VL INTTYPE
, AS_LOOKUPS ASLKP1
, AS_INTEREST_CODES_VL INTC1
, AS_INTEREST_CODES_VL INTC2
, AS_SCRIPT_ANSWER_ACTIONS AA
WHERE AA.TYPE = 'PI'
AND AA.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID(+)
AND AA.INTEREST_STATUS_CODE = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'INTEREST_STATUS'
AND AA.PRIMARY_INTEREST_CODE_ID = INTC1.INTEREST_CODE_ID(+)
AND AA.SECONDARY_INTEREST_CODE_ID = INTC2.INTEREST_CODE_ID(+)