[Home] [Help]
View: AS_SCRIPT_ANS_ACT_EE_V
Product: | AS - Sales Foundation |
Description: | Event answer actions view |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
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.PROMOTION_ID
, P.CODE
, P.DESCRIPTION
, EF.CITY
, P.EVENT_START_DATE
FROM AS_EVENT_FACILITIES EF
, AS_SCRIPT_ANSWER_ACTIONS AA
, AS_PROMOTIONS P
WHERE AA.TYPE = 'EE'
AND P.PROMOTION_ID = AA.PROMOTION_ID
AND EF.EVENT_FACILITY_ID = P.EVENT_FACILITY_ID
Columns
Name |
ROW_ID |
SCRIPT_ANSWER_ACTION_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
PRE_DEF_ANSWER_ID |
PROMOTION_ID |
EVENT_CODE |
DESCRIPTION |
EVENT_CITY |
EVENT_DATE |