VIEW: OPI.EDW_OPI_LOT_M#

Source

View Text - Preformatted

select ALL_ALL_PK ALL_ALL_PK, ALL_ALL_PK_KEY ALL_ALL_PK_KEY, ALL_NAME ALL_NAME, LOT_DESCRIPTION LOT_DESCRIPTION, LOT_EDW_LOT_DP LOT_EDW_LOT_DP, LOT_EDW_LOT_PK LOT_EDW_LOT_PK, LOT_EDW_LOT_PK_KEY LOT_EDW_LOT_PK_KEY, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE, LOT_INVENTORY_ITEM_ID LOT_INVENTORY_ITEM_ID, LOT_ITEM_REVISION LOT_ITEM_REVISION, LOT_LOT LOT_LOT, LOT_LOT_NAME LOT_LOT_NAME, LOT_NAME LOT_NAME, LOT_NETTABLE_FLAG LOT_NETTABLE_FLAG, LOT_ORGANIZATION_ID LOT_ORGANIZATION_ID, LOT_PARENT_LOT LOT_PARENT_LOT, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LOT_USER_ATTRIBUTE1 LOT_USER_ATTRIBUTE1, LOT_USER_ATTRIBUTE2 LOT_USER_ATTRIBUTE2, LOT_USER_ATTRIBUTE3 LOT_USER_ATTRIBUTE3, LOT_USER_ATTRIBUTE4 LOT_USER_ATTRIBUTE4, LOT_USER_ATTRIBUTE5 LOT_USER_ATTRIBUTE5 from "OPI"."EDW_OPI_LOT_M"

View Text - HTML Formatted

SELECT ALL_ALL_PK ALL_ALL_PK
, ALL_ALL_PK_KEY ALL_ALL_PK_KEY
, ALL_NAME ALL_NAME
, LOT_DESCRIPTION LOT_DESCRIPTION
, LOT_EDW_LOT_DP LOT_EDW_LOT_DP
, LOT_EDW_LOT_PK LOT_EDW_LOT_PK
, LOT_EDW_LOT_PK_KEY LOT_EDW_LOT_PK_KEY
, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE
, LOT_INVENTORY_ITEM_ID LOT_INVENTORY_ITEM_ID
, LOT_ITEM_REVISION LOT_ITEM_REVISION
, LOT_LOT LOT_LOT
, LOT_LOT_NAME LOT_LOT_NAME
, LOT_NAME LOT_NAME
, LOT_NETTABLE_FLAG LOT_NETTABLE_FLAG
, LOT_ORGANIZATION_ID LOT_ORGANIZATION_ID
, LOT_PARENT_LOT LOT_PARENT_LOT
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOT_USER_ATTRIBUTE1 LOT_USER_ATTRIBUTE1
, LOT_USER_ATTRIBUTE2 LOT_USER_ATTRIBUTE2
, LOT_USER_ATTRIBUTE3 LOT_USER_ATTRIBUTE3
, LOT_USER_ATTRIBUTE4 LOT_USER_ATTRIBUTE4
, LOT_USER_ATTRIBUTE5 LOT_USER_ATTRIBUTE5
FROM "OPI"."EDW_OPI_LOT_M"