VIEW: GMF.CM_SCST_LED#

Source

View Text - Preformatted

select RUDTL_ID RUDTL_ID, STD_QTY STD_QTY, FORM_PROD_UM FORM_PROD_UM, ROUTING_QTY ROUTING_QTY, PRODUCT_QTY PRODUCT_QTY, COST_ALLOC COST_ALLOC, CMPNTCOST_ID CMPNTCOST_ID, ITEM_ID ITEM_ID, LINE_TYPE LINE_TYPE, ITEM_QTY ITEM_QTY, ITEM_FMQTY ITEM_FMQTY, ITEM_FMQTY_UM ITEM_FMQTY_UM, WHSE_CODE WHSE_CODE, CMPNT_COST CMPNT_COST, RESOURCES RESOURCES, RESOURCE_COUNT RESOURCE_COUNT, RESOURCE_USAGE RESOURCE_USAGE, NOMINAL_COST NOMINAL_COST, USAGE_UM USAGE_UM, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETE_MARK DELETE_MARK, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, FORM_PROD_UOM FORM_PROD_UOM, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_FMQTY_UOM ITEM_FMQTY_UOM, ORGANIZATION_ID ORGANIZATION_ID, USAGE_UOM USAGE_UOM from "GMF"."CM_SCST_LED"

View Text - HTML Formatted

SELECT RUDTL_ID RUDTL_ID
, STD_QTY STD_QTY
, FORM_PROD_UM FORM_PROD_UM
, ROUTING_QTY ROUTING_QTY
, PRODUCT_QTY PRODUCT_QTY
, COST_ALLOC COST_ALLOC
, CMPNTCOST_ID CMPNTCOST_ID
, ITEM_ID ITEM_ID
, LINE_TYPE LINE_TYPE
, ITEM_QTY ITEM_QTY
, ITEM_FMQTY ITEM_FMQTY
, ITEM_FMQTY_UM ITEM_FMQTY_UM
, WHSE_CODE WHSE_CODE
, CMPNT_COST CMPNT_COST
, RESOURCES RESOURCES
, RESOURCE_COUNT RESOURCE_COUNT
, RESOURCE_USAGE RESOURCE_USAGE
, NOMINAL_COST NOMINAL_COST
, USAGE_UM USAGE_UM
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETE_MARK DELETE_MARK
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FORM_PROD_UOM FORM_PROD_UOM
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_FMQTY_UOM ITEM_FMQTY_UOM
, ORGANIZATION_ID ORGANIZATION_ID
, USAGE_UOM USAGE_UOM
FROM "GMF"."CM_SCST_LED"