[Home] [Help]
View: AS_SCRIPT_CODES_V
| Product: | AS - Sales Foundation |
|---|
| Description: | Script codes view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT P.PROMOTION_ID
, P.CODE
, P.NAME
, P.SCRIPT_TYPE
, P.LANGUAGE
, P.DESCRIPTION
, P.ENABLED_FLAG
, ASLKP1.MEANING
, ASLKP2.MEANING
, P.SCRIPT_EVENT_EVAL_FLAG
FROM AS_LOOKUPS ASLKP1
, AS_LOOKUPS ASLKP2
, AS_PROMOTIONS P
WHERE P.TYPE = 'S'
AND P.SCRIPT_TYPE = ASLKP1.LOOKUP_CODE(+)
AND ASLKP1.LOOKUP_TYPE(+) = 'SCRIPT_TYPE'
AND P.LANGUAGE = ASLKP2.LOOKUP_CODE(+)
AND ASLKP2.LOOKUP_TYPE(+) = 'LANGUAGE'
Columns
| Name |
| SCRIPT_ID |
| CODE |
| NAME |
| TYPE_CODE |
| LANGUAGE_CODE |
| DESCRIPTION |
| ENABLED_FLAG |
| TYPE |
| LANGUAGE |
| SCRIPT_EVENT_EVAL_FLAG |