1. Tables and Views for Sales and Fusion Service
  2. SVC_STD_TXT_VARIABLES_V

SVC_STD_TXT_VARIABLES_V

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: VIEW

Columns

Name

VARIABLE_TYPE

VARIABLE_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

VARIABLE_CODE

DESCRIPTION

CONTEXT

DATACONTROL

OBJECT

ATTRIBUTE

VAL_CHAR

VAL_DATE

VAL_TIMESTAMP

VAL_NUMBER

STRIPE_CD

BU_ORG_ID

Query

SQL_Statement

SELECT 'System Defined' VARIABLE_TYPE,

S.VARIABLE_ID,

S.CREATED_BY,

S.CREATION_DATE,

S.LAST_UPDATED_BY,

S.LAST_UPDATE_DATE,

S.LAST_UPDATE_LOGIN,

S.OBJECT_VERSION_NUMBER,

S.VARIABLE_CODE,

S.DESCRIPTION,

S.CONTEXT,

S.DATACONTROL,

S.OBJECT,

S.ATTRIBUTE,

S.VAL_CHAR,

S.VAL_DATE,

S.VAL_TIMESTAMP,

S.VAL_NUMBER,

S.STRIPE_CD,

null BU_ORG_ID

FROM SVC_STD_TXT_SYS_VARS S

UNION

SELECT 'User Defined' VARIABLE_TYPE,

U.VARIABLE_ID,

U.CREATED_BY,

U.CREATION_DATE,

U.LAST_UPDATED_BY,

U.LAST_UPDATE_DATE,

U.LAST_UPDATE_LOGIN,

U.OBJECT_VERSION_NUMBER,

U.VARIABLE_CODE,

U.DESCRIPTION,

U.CONTEXT,

U.DATACONTROL,

U.OBJECT,

U.ATTRIBUTE,

U.VAL_CHAR,

U.VAL_DATE,

U.VAL_TIMESTAMP,

U.VAL_NUMBER,

U.STRIPE_CD,

U.BU_ORG_ID

FROM SVC_STD_TXT_USR_VARS U