VIEW: ENI.ENI_OLTP_ITEM_STAR#

Source

View Text - Preformatted

select ID ID, VALUE VALUE, ORGANIZATION_CODE ORGANIZATION_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, PO_CATEGORY_ID PO_CATEGORY_ID, PO_CATEGORY_SET_ID PO_CATEGORY_SET_ID, PO_CONCAT_SEG PO_CONCAT_SEG, INV_CATEGORY_ID INV_CATEGORY_ID, INV_CATEGORY_SET_ID INV_CATEGORY_SET_ID, INV_CONCAT_SEG INV_CONCAT_SEG, VBH_CATEGORY_ID VBH_CATEGORY_ID, VBH_CATEGORY_SET_ID VBH_CATEGORY_SET_ID, VBH_CONCAT_SEG VBH_CONCAT_SEG, MASTER_ID MASTER_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID, PRIMARY_UOM_CODE PRIMARY_UOM_CODE, UNIT_WEIGHT UNIT_WEIGHT, UNIT_VOLUME UNIT_VOLUME, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME_UOM_CODE VOLUME_UOM_CODE, EAM_ITEM_TYPE EAM_ITEM_TYPE from "ENI"."ENI_OLTP_ITEM_STAR"

View Text - HTML Formatted

SELECT ID ID
, VALUE VALUE
, ORGANIZATION_CODE ORGANIZATION_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PO_CATEGORY_ID PO_CATEGORY_ID
, PO_CATEGORY_SET_ID PO_CATEGORY_SET_ID
, PO_CONCAT_SEG PO_CONCAT_SEG
, INV_CATEGORY_ID INV_CATEGORY_ID
, INV_CATEGORY_SET_ID INV_CATEGORY_SET_ID
, INV_CONCAT_SEG INV_CONCAT_SEG
, VBH_CATEGORY_ID VBH_CATEGORY_ID
, VBH_CATEGORY_SET_ID VBH_CATEGORY_SET_ID
, VBH_CONCAT_SEG VBH_CONCAT_SEG
, MASTER_ID MASTER_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, ITEM_CATALOG_GROUP_ID ITEM_CATALOG_GROUP_ID
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, UNIT_WEIGHT UNIT_WEIGHT
, UNIT_VOLUME UNIT_VOLUME
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, EAM_ITEM_TYPE EAM_ITEM_TYPE
FROM "ENI"."ENI_OLTP_ITEM_STAR"