VIEW: OPI.EDW_MTL_INVENTORY_LOC_M#

Source

View Text - Preformatted

select ALL_NAME ALL_NAME, ALL_PK ALL_PK, ALL_PK_KEY ALL_PK_KEY, CREATION_DATE CREATION_DATE, INVL_NAME INVL_NAME, INVL_DESCRIPTION INVL_DESCRIPTION, INVL_ENABLED_FLAG INVL_ENABLED_FLAG, INVL_INSTANCE_CODE INVL_INSTANCE_CODE, INVL_LOCATOR_DP INVL_LOCATOR_DP, INVL_LOCATOR_NAME INVL_LOCATOR_NAME, INVL_LOCATOR_PK INVL_LOCATOR_PK, INVL_LOCATOR_PK_KEY INVL_LOCATOR_PK_KEY, INVL_USER_ATTRIBUTE1 INVL_USER_ATTRIBUTE1, INVL_USER_ATTRIBUTE2 INVL_USER_ATTRIBUTE2, INVL_USER_ATTRIBUTE3 INVL_USER_ATTRIBUTE3, INVL_USER_ATTRIBUTE4 INVL_USER_ATTRIBUTE4, INVL_USER_ATTRIBUTE5 INVL_USER_ATTRIBUTE5, LAST_UPDATE_DATE LAST_UPDATE_DATE, OU_BUSINESS_GROUP OU_BUSINESS_GROUP, OU_DATE_FROM OU_DATE_FROM, OU_DATE_TO OU_DATE_TO, OU_INSTANCE_CODE OU_INSTANCE_CODE, OU_INT_EXT_FLAG OU_INT_EXT_FLAG, OU_NAME OU_NAME, OU_OPERATING_UNIT_DP OU_OPERATING_UNIT_DP, OU_OPERATING_UNIT_PK OU_OPERATING_UNIT_PK, OU_OPERATING_UNIT_PK_KEY OU_OPERATING_UNIT_PK_KEY, OU_ORG_CODE OU_ORG_CODE, OU_ORG_TYPE OU_ORG_TYPE, OU_PRIMARY_CST_MTHD OU_PRIMARY_CST_MTHD, OU_USER_ATTRIBUTE1 OU_USER_ATTRIBUTE1, OU_USER_ATTRIBUTE2 OU_USER_ATTRIBUTE2, OU_USER_ATTRIBUTE3 OU_USER_ATTRIBUTE3, OU_USER_ATTRIBUTE4 OU_USER_ATTRIBUTE4, OU_USER_ATTRIBUTE5 OU_USER_ATTRIBUTE5, PCMP_DESCRIPTION PCMP_DESCRIPTION, PCMP_INSTANCE_CODE PCMP_INSTANCE_CODE, PCMP_NAME PCMP_NAME, PCMP_OPM_COMPANY_PK PCMP_OPM_COMPANY_PK, PCMP_OPM_COMPANY_CODE PCMP_OPM_COMPANY_CODE, PCMP_OPM_COMPANY_DP PCMP_OPM_COMPANY_DP, PCMP_OPM_COMPANY_NAME PCMP_OPM_COMPANY_NAME, PCMP_OPM_COMPANY_PK_KEY PCMP_OPM_COMPANY_PK_KEY, PCMP_USER_ATTRIBUTE1 PCMP_USER_ATTRIBUTE1, PCMP_USER_ATTRIBUTE2 PCMP_USER_ATTRIBUTE2, PCMP_USER_ATTRIBUTE3 PCMP_USER_ATTRIBUTE3, PCMP_USER_ATTRIBUTE4 PCMP_USER_ATTRIBUTE4, PCMP_USER_ATTRIBUTE5 PCMP_USER_ATTRIBUTE5, PLNT_NAME PLNT_NAME, PLNT_ORGANIZATION_NAME PLNT_ORGANIZATION_NAME, PLNT_DESCRIPTION PLNT_DESCRIPTION, PLNT_INSTANCE_CODE PLNT_INSTANCE_CODE, PLNT_ORGANIZATION_CODE PLNT_ORGANIZATION_CODE, PLNT_PLANT_DP PLNT_PLANT_DP, PLNT_PLANT_PK PLNT_PLANT_PK, PLNT_PLANT_PK_KEY PLNT_PLANT_PK_KEY, PLNT_USER_ATTRIBUTE1 PLNT_USER_ATTRIBUTE1, PLNT_USER_ATTRIBUTE2 PLNT_USER_ATTRIBUTE2, PLNT_USER_ATTRIBUTE3 PLNT_USER_ATTRIBUTE3, PLNT_USER_ATTRIBUTE4 PLNT_USER_ATTRIBUTE4, PLNT_USER_ATTRIBUTE5 PLNT_USER_ATTRIBUTE5, PORG_DESCRIPTION PORG_DESCRIPTION, PORG_INSTANCE_CODE PORG_INSTANCE_CODE, PORG_NAME PORG_NAME, PORG_OPM_ORGANIZATION_CODE PORG_OPM_ORGANIZATION_CODE, PORG_OPM_ORGANIZATION_DP PORG_OPM_ORGANIZATION_DP, PORG_OPM_ORGANIZATION_NAME PORG_OPM_ORGANIZATION_NAME, PORG_OPM_ORGANIZATION_PK PORG_OPM_ORGANIZATION_PK, PORG_OPM_ORGANIZATION_PK_KEY PORG_OPM_ORGANIZATION_PK_KEY, PORG_USER_ATTRIBUTE1 PORG_USER_ATTRIBUTE1, PORG_USER_ATTRIBUTE2 PORG_USER_ATTRIBUTE2, PORG_USER_ATTRIBUTE3 PORG_USER_ATTRIBUTE3, PORG_USER_ATTRIBUTE4 PORG_USER_ATTRIBUTE4, PORG_USER_ATTRIBUTE5 PORG_USER_ATTRIBUTE5, SUBI_NAME SUBI_NAME, SUBI_DESCRIPTION SUBI_DESCRIPTION, SUBI_INSTANCE_CODE SUBI_INSTANCE_CODE, SUBI_STOCK_ROOM SUBI_STOCK_ROOM, SUBI_STOCK_ROOM_DP SUBI_STOCK_ROOM_DP, SUBI_STOCK_ROOM_PK SUBI_STOCK_ROOM_PK, SUBI_STOCK_ROOM_PK_KEY SUBI_STOCK_ROOM_PK_KEY, SUBI_USER_ATTRIBUTE1 SUBI_USER_ATTRIBUTE1, SUBI_USER_ATTRIBUTE2 SUBI_USER_ATTRIBUTE2, SUBI_USER_ATTRIBUTE3 SUBI_USER_ATTRIBUTE3, SUBI_USER_ATTRIBUTE4 SUBI_USER_ATTRIBUTE4, SUBI_USER_ATTRIBUTE5 SUBI_USER_ATTRIBUTE5 from "OPI"."EDW_MTL_INVENTORY_LOC_M"

View Text - HTML Formatted

SELECT ALL_NAME ALL_NAME
, ALL_PK ALL_PK
, ALL_PK_KEY ALL_PK_KEY
, CREATION_DATE CREATION_DATE
, INVL_NAME INVL_NAME
, INVL_DESCRIPTION INVL_DESCRIPTION
, INVL_ENABLED_FLAG INVL_ENABLED_FLAG
, INVL_INSTANCE_CODE INVL_INSTANCE_CODE
, INVL_LOCATOR_DP INVL_LOCATOR_DP
, INVL_LOCATOR_NAME INVL_LOCATOR_NAME
, INVL_LOCATOR_PK INVL_LOCATOR_PK
, INVL_LOCATOR_PK_KEY INVL_LOCATOR_PK_KEY
, INVL_USER_ATTRIBUTE1 INVL_USER_ATTRIBUTE1
, INVL_USER_ATTRIBUTE2 INVL_USER_ATTRIBUTE2
, INVL_USER_ATTRIBUTE3 INVL_USER_ATTRIBUTE3
, INVL_USER_ATTRIBUTE4 INVL_USER_ATTRIBUTE4
, INVL_USER_ATTRIBUTE5 INVL_USER_ATTRIBUTE5
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OU_BUSINESS_GROUP OU_BUSINESS_GROUP
, OU_DATE_FROM OU_DATE_FROM
, OU_DATE_TO OU_DATE_TO
, OU_INSTANCE_CODE OU_INSTANCE_CODE
, OU_INT_EXT_FLAG OU_INT_EXT_FLAG
, OU_NAME OU_NAME
, OU_OPERATING_UNIT_DP OU_OPERATING_UNIT_DP
, OU_OPERATING_UNIT_PK OU_OPERATING_UNIT_PK
, OU_OPERATING_UNIT_PK_KEY OU_OPERATING_UNIT_PK_KEY
, OU_ORG_CODE OU_ORG_CODE
, OU_ORG_TYPE OU_ORG_TYPE
, OU_PRIMARY_CST_MTHD OU_PRIMARY_CST_MTHD
, OU_USER_ATTRIBUTE1 OU_USER_ATTRIBUTE1
, OU_USER_ATTRIBUTE2 OU_USER_ATTRIBUTE2
, OU_USER_ATTRIBUTE3 OU_USER_ATTRIBUTE3
, OU_USER_ATTRIBUTE4 OU_USER_ATTRIBUTE4
, OU_USER_ATTRIBUTE5 OU_USER_ATTRIBUTE5
, PCMP_DESCRIPTION PCMP_DESCRIPTION
, PCMP_INSTANCE_CODE PCMP_INSTANCE_CODE
, PCMP_NAME PCMP_NAME
, PCMP_OPM_COMPANY_PK PCMP_OPM_COMPANY_PK
, PCMP_OPM_COMPANY_CODE PCMP_OPM_COMPANY_CODE
, PCMP_OPM_COMPANY_DP PCMP_OPM_COMPANY_DP
, PCMP_OPM_COMPANY_NAME PCMP_OPM_COMPANY_NAME
, PCMP_OPM_COMPANY_PK_KEY PCMP_OPM_COMPANY_PK_KEY
, PCMP_USER_ATTRIBUTE1 PCMP_USER_ATTRIBUTE1
, PCMP_USER_ATTRIBUTE2 PCMP_USER_ATTRIBUTE2
, PCMP_USER_ATTRIBUTE3 PCMP_USER_ATTRIBUTE3
, PCMP_USER_ATTRIBUTE4 PCMP_USER_ATTRIBUTE4
, PCMP_USER_ATTRIBUTE5 PCMP_USER_ATTRIBUTE5
, PLNT_NAME PLNT_NAME
, PLNT_ORGANIZATION_NAME PLNT_ORGANIZATION_NAME
, PLNT_DESCRIPTION PLNT_DESCRIPTION
, PLNT_INSTANCE_CODE PLNT_INSTANCE_CODE
, PLNT_ORGANIZATION_CODE PLNT_ORGANIZATION_CODE
, PLNT_PLANT_DP PLNT_PLANT_DP
, PLNT_PLANT_PK PLNT_PLANT_PK
, PLNT_PLANT_PK_KEY PLNT_PLANT_PK_KEY
, PLNT_USER_ATTRIBUTE1 PLNT_USER_ATTRIBUTE1
, PLNT_USER_ATTRIBUTE2 PLNT_USER_ATTRIBUTE2
, PLNT_USER_ATTRIBUTE3 PLNT_USER_ATTRIBUTE3
, PLNT_USER_ATTRIBUTE4 PLNT_USER_ATTRIBUTE4
, PLNT_USER_ATTRIBUTE5 PLNT_USER_ATTRIBUTE5
, PORG_DESCRIPTION PORG_DESCRIPTION
, PORG_INSTANCE_CODE PORG_INSTANCE_CODE
, PORG_NAME PORG_NAME
, PORG_OPM_ORGANIZATION_CODE PORG_OPM_ORGANIZATION_CODE
, PORG_OPM_ORGANIZATION_DP PORG_OPM_ORGANIZATION_DP
, PORG_OPM_ORGANIZATION_NAME PORG_OPM_ORGANIZATION_NAME
, PORG_OPM_ORGANIZATION_PK PORG_OPM_ORGANIZATION_PK
, PORG_OPM_ORGANIZATION_PK_KEY PORG_OPM_ORGANIZATION_PK_KEY
, PORG_USER_ATTRIBUTE1 PORG_USER_ATTRIBUTE1
, PORG_USER_ATTRIBUTE2 PORG_USER_ATTRIBUTE2
, PORG_USER_ATTRIBUTE3 PORG_USER_ATTRIBUTE3
, PORG_USER_ATTRIBUTE4 PORG_USER_ATTRIBUTE4
, PORG_USER_ATTRIBUTE5 PORG_USER_ATTRIBUTE5
, SUBI_NAME SUBI_NAME
, SUBI_DESCRIPTION SUBI_DESCRIPTION
, SUBI_INSTANCE_CODE SUBI_INSTANCE_CODE
, SUBI_STOCK_ROOM SUBI_STOCK_ROOM
, SUBI_STOCK_ROOM_DP SUBI_STOCK_ROOM_DP
, SUBI_STOCK_ROOM_PK SUBI_STOCK_ROOM_PK
, SUBI_STOCK_ROOM_PK_KEY SUBI_STOCK_ROOM_PK_KEY
, SUBI_USER_ATTRIBUTE1 SUBI_USER_ATTRIBUTE1
, SUBI_USER_ATTRIBUTE2 SUBI_USER_ATTRIBUTE2
, SUBI_USER_ATTRIBUTE3 SUBI_USER_ATTRIBUTE3
, SUBI_USER_ATTRIBUTE4 SUBI_USER_ATTRIBUTE4
, SUBI_USER_ATTRIBUTE5 SUBI_USER_ATTRIBUTE5
FROM "OPI"."EDW_MTL_INVENTORY_LOC_M"