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

OKC_BUS_VARIABLES_VL

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

ROW_ID

VARIABLE_DEFAULT_VALUE

VARIABLE_CODE

OBJECT_VERSION_NUMBER

VARIABLE_TYPE

EXTERNAL_YN

APPLICATION_ID

VARIABLE_INTENT

CONTRACT_EXPERT_YN

DISABLED_YN

VARIABLE_DATATYPE

VALUE_SET_ID

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

VARIABLE_NAME

DESCRIPTION

XPRT_VALUE_SET_NAME

LINE_LEVEL_FLAG

DATE_PUBLISHED

ORIG_SYSTEM_REFERENCE_CODE

ORIG_SYSTEM_REFERENCE_ID1

ORIG_SYSTEM_REFERENCE_ID2

METHOD_NAME

VARIABLE_SOURCE

MODULE_ID

SEEDED_FLAG_YN

METHOD_TYPE

OBJECT_LOOKUP_CODE

CHILD_OBJECT_VO

OBJECT_ID_ATTRIBUTE

OBJECT_VALUE_ATTRIBUTE

XPRT_LOOKUP_TYPE

PRINT_LAYOUT_NAME

Query

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.VARIABLE_DEFAULT_VALUE,

B.VARIABLE_CODE,

B.OBJECT_VERSION_NUMBER,

B.VARIABLE_TYPE,

B.EXTERNAL_YN,

B.APPLICATION_ID,

B.VARIABLE_INTENT,

B.CONTRACT_EXPERT_YN,

B.DISABLED_YN,

B.VARIABLE_DATATYPE,

B.VALUE_SET_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.ATTRIBUTE16,

B.ATTRIBUTE17,

B.ATTRIBUTE18,

B.ATTRIBUTE19,

B.ATTRIBUTE20,

B.ATTRIBUTE21,

B.ATTRIBUTE22,

B.ATTRIBUTE23,

B.ATTRIBUTE24,

B.ATTRIBUTE25,

B.ATTRIBUTE26,

B.ATTRIBUTE27,

B.ATTRIBUTE28,

B.ATTRIBUTE29,

B.ATTRIBUTE30,

T.VARIABLE_NAME,

T.DESCRIPTION,

B.XPRT_VALUE_SET_NAME,

B.LINE_LEVEL_FLAG,

B.DATE_PUBLISHED,

B.ORIG_SYSTEM_REFERENCE_CODE,

B.ORIG_SYSTEM_REFERENCE_ID1,

B.ORIG_SYSTEM_REFERENCE_ID2,

B.METHOD_NAME,

B.VARIABLE_SOURCE,

B.MODULE_ID MODULE_ID,

B.SEEDED_FLAG_YN,

B.METHOD_TYPE,

B.OBJECT_LOOKUP_CODE,

B.CHILD_OBJECT_VO,

B.OBJECT_ID_ATTRIBUTE,

B.OBJECT_VALUE_ATTRIBUTE,

B.XPRT_LOOKUP_TYPE,

T.PRINT_LAYOUT_NAME

FROM

OKC_BUS_VARIABLES_TL T,

OKC_BUS_VARIABLES_B B

WHERE

B.VARIABLE_CODE = T.VARIABLE_CODE AND T.LANGUAGE = USERENV('LANG')