Product: | AS - Sales Foundation |
---|---|
Description: | Create lead 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.LAST_UPDATE_LOGIN
, AA.PRE_DEF_ANSWER_ID
, AA.LEAD_NAME
, AA.RANK
, ASLKP1.MEANING
, AA.SALES_STAGE_ID
, AA.INVENTORY_ITEM_ID
, AA.ORGANIZATION_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
, ASLKP2.MEANING
, ASSAL.NAME
FROM AS_INTEREST_CODES_VL INTC1
, AS_INTEREST_CODES_VL INTC2
, AS_LOOKUPS ASLKP1
, AS_SALES_STAGES_VL ASSAL
, AS_INTEREST_TYPES_VL INTTYPE
, AS_LOOKUPS ASLKP2
, AS_SCRIPT_ANSWER_ACTIONS AA
WHERE AA.TYPE = 'CL'
AND AA.PRIMARY_INTEREST_CODE_ID = INTC1.INTEREST_CODE_ID(+)
AND AA.SECONDARY_INTEREST_CODE_ID = INTC2.INTEREST_CODE_ID(+)
AND AA.RANK = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'RANK'
AND AA.SALES_STAGE_ID = ASSAL.SALES_STAGE_ID(+)
AND AA.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID(+)
AND AA.INTEREST_STATUS_CODE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'INTEREST_STATUS'