VIEW: ASL.ASL_INVENTORY_ITEM_DENORM#

Source

View Text - Preformatted

select CATEGORY_SET_ID CATEGORY_SET_ID, CATEGORY_ID CATEGORY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, INVENTORY_ITEM_NUMBER INVENTORY_ITEM_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, LANGUAGE_CODE LANGUAGE_CODE, UOM_CODE UOM_CODE, UOM_DESCRIPTION UOM_DESCRIPTION, INTEREST_TYPE_ID INTEREST_TYPE_ID, INTEREST_TYPE INTEREST_TYPE, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID, PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID, SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE, SHIPPLE_FLAG SHIPPLE_FLAG, SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG, TAXABLE_FLAG TAXABLE_FLAG, RETURNABLE_FLAG RETURNABLE_FLAG, SERVICEABLE_FLAG SERVICEABLE_FLAG, ACTIVE_FLAG ACTIVE_FLAG, BOM_ENABLED_FLAG BOM_ENABLED_FLAG, VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG, PRIMARY_UOM_CODE PRIMARY_UOM_CODE from "ASL"."ASL_INVENTORY_ITEM_DENORM"

View Text - HTML Formatted

SELECT CATEGORY_SET_ID CATEGORY_SET_ID
, CATEGORY_ID CATEGORY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, INVENTORY_ITEM_NUMBER INVENTORY_ITEM_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, LANGUAGE_CODE LANGUAGE_CODE
, UOM_CODE UOM_CODE
, UOM_DESCRIPTION UOM_DESCRIPTION
, INTEREST_TYPE_ID INTEREST_TYPE_ID
, INTEREST_TYPE INTEREST_TYPE
, PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE
, SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE
, SHIPPLE_FLAG SHIPPLE_FLAG
, SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG
, TAXABLE_FLAG TAXABLE_FLAG
, RETURNABLE_FLAG RETURNABLE_FLAG
, SERVICEABLE_FLAG SERVICEABLE_FLAG
, ACTIVE_FLAG ACTIVE_FLAG
, BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG
, PRIMARY_UOM_CODE PRIMARY_UOM_CODE
FROM "ASL"."ASL_INVENTORY_ITEM_DENORM"