1. Tables and Views for SCM
  2. WIS_DISPENSE_AREAS_VL

WIS_DISPENSE_AREAS_VL

Details

  • Schema: FUSION

  • Object owner: WIS

  • Object type: VIEW

Columns

Name

DISPENSE_AREA_ID

DISPENSE_AREA_CODE

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

DISPENSE_AREA_NAME

DISPENSE_AREA_DESC

SUBINVENTORY_CODE

INACTIVE_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT

wdab.dispense_area_id,

wdab.dispense_area_code,

wdab.object_version_number,

wdab.organization_id,

wdat.dispense_area_name,

wdat.dispense_area_desc,

wdab.subinventory_code,

wdab.inactive_date,

wdab.created_by,

wdab.creation_date,

wdab.last_updated_by,

wdab.last_update_date,

wdab.last_update_login,

wdab.attribute_category,

wdab.attribute_char1,

wdab.attribute_char2,

wdab.attribute_char3,

wdab.attribute_char4,

wdab.attribute_char5,

wdab.attribute_char6,

wdab.attribute_char7,

wdab.attribute_char8,

wdab.attribute_char9,

wdab.attribute_char10,

wdab.attribute_char11,

wdab.attribute_char12,

wdab.attribute_char13,

wdab.attribute_char14,

wdab.attribute_char15,

wdab.attribute_char16,

wdab.attribute_char17,

wdab.attribute_char18,

wdab.attribute_char19,

wdab.attribute_char20,

wdab.attribute_number1,

wdab.attribute_number2,

wdab.attribute_number3,

wdab.attribute_number4,

wdab.attribute_number5,

wdab.attribute_number6,

wdab.attribute_number7,

wdab.attribute_number8,

wdab.attribute_number9,

wdab.attribute_number10,

wdab.attribute_date1,

wdab.attribute_date2,

wdab.attribute_date3,

wdab.attribute_date4,

wdab.attribute_date5,

wdab.attribute_timestamp1,

wdab.attribute_timestamp2,

wdab.attribute_timestamp3,

wdab.attribute_timestamp4,

wdab.attribute_timestamp5

FROM

wis_dispense_areas_b wdab,

wis_dispense_areas_tl wdat

WHERE

wdab.dispense_area_id = wdat.dispense_area_id

AND wdat.language = userenv('LANG')