[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | Script actual answers view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT SAA.PRE_DEF_ANSWER_ID
, PDA.LABEL
, SAA.TYPE
, LKP3.MEANING
, SAA.INTEREST_TYPE_ID
, IT.INTEREST_TYPE
, SAA.PRIMARY_INTEREST_CODE_ID
, DECODE(SAA.TYPE
, 'CL'
, IC1.CODE
, 'PI'
, IC1.CODE
, 'EE'
, PROM.CODE
, 'SC'
, PROM.CODE
, NULL)
, SAA.SECONDARY_INTEREST_CODE_ID
, DECODE(SAA.TYPE
, 'CL'
, IC2.CODE
, 'PI'
, IC2.CODE
, NULL)
, SAA.ORGANIZATION_ID
, SAA.INVENTORY_ITEM_ID
, SAA.PROMOTION_ID
, SAA.DESCRIPTION
, SAA.LEAD_NAME
, SAA.RANK
, LKP2.MEANING
, SAA.SALES_STAGE_ID
, SS.NAME
, SAA.INTEREST_STATUS_CODE
, LKP1.MEANING
FROM AS_SCRIPT_PRE_DEFINED_ANSWERS PDA
, AS_SCRIPT_ANSWER_ACTIONS SAA
, AS_INTEREST_TYPES_VL IT
, AS_PROMOTIONS PROM
, AS_INTEREST_CODES_VL IC1
, AS_INTEREST_CODES_VL IC2
, AS_LOOKUPS LKP1
, AS_LOOKUPS LKP2
, AS_LOOKUPS LKP3
, AS_SALES_STAGES_VL SS
WHERE PDA.SCRIPT_PRE_DEF_ANSWER_ID = SAA.PRE_DEF_ANSWER_ID AND SAA.INTEREST_TYPE_ID = IT.INTEREST_TYPE_ID(+) AND SAA.PROMOTION_ID = PROM.PROMOTION_ID(+) AND SAA.PRIMARY_INTEREST_CODE_ID = IC1.INTEREST_CODE_ID(+) AND SAA.SECONDARY_INTEREST_CODE_ID = IC2.INTEREST_CODE_ID(+)
AND SAA.SALES_STAGE_ID = SS.SALES_STAGE_ID(+) AND SAA.INTEREST_STATUS_CODE = LKP1.LOOKUP_CODE(+) AND LKP1.LOOKUP_TYPE(+) = 'INTEREST_STATUS' AND SAA.RANK = LKP2.LOOKUP_CODE(+) AND LKP2.LOOKUP_TYPE(+) = 'RANK' AND SAA.TYPE = LKP3.LOOKUP_CODE(+) AND LKP3.LOOKUP_TYPE(+) = 'PRE_DEFINED_ACTION_TYPE'