[Home] [Help]
View: AS_SCRIPT_ANS_ACT_SC_V
Product: | AS - Sales Foundation |
Description: | Send collateral 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
, AA.INVENTORY_ITEM_ID
, AA.ORGANIZATION_ID
, P.DESCRIPTION
FROM AS_SCRIPT_ANSWER_ACTIONS AA
, AS_PROMOTIONS P
WHERE AA.PROMOTION_ID = P.PROMOTION_ID
AND AA.TYPE = 'SC'
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 |
COLLATERAL_CODE |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
DESCRIPTION |