VIEW: GMD.GMD_COA_HEADERS#

Source

View Text - Preformatted

select GMD_COA_ID GMD_COA_ID, ORDER_ID ORDER_ID, LINE_ID LINE_ID, ORGN_CODE ORGN_CODE, ORDER_NO ORDER_NO, CUSTPO_NO CUSTPO_NO, SHIPDATE SHIPDATE, CUST_ID CUST_ID, CUST_NO CUST_NO, CUST_NAME CUST_NAME, BOL_ID BOL_ID, BOL_NO BOL_NO, ITEM_ID ITEM_ID, ITEM_NO ITEM_NO, ITEM_DESC1 ITEM_DESC1, WHSE_CODE WHSE_CODE, WHSE_NAME WHSE_NAME, LOT_ID LOT_ID, LOT_NO LOT_NO, LOT_DESC LOT_DESC, SUBLOT_NO SUBLOT_NO, ORDER_QTY1 ORDER_QTY1, ORDER_UM1 ORDER_UM1, ORDER_QTY2 ORDER_QTY2, ORDER_UM2 ORDER_UM2, SHIP_QTY1 SHIP_QTY1, SHIP_QTY2 SHIP_QTY2, REPORT_TITLE REPORT_TITLE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OPM_CUST_ID OPM_CUST_ID, SESSION_ID SESSION_ID, SHIP_UOM1 SHIP_UOM1, SHIP_UOM2 SHIP_UOM2, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_DESCRIPTION ITEM_DESCRIPTION, ITEM_NUMBER ITEM_NUMBER, LOT_DESCRIPTION LOT_DESCRIPTION, LOT_NUMBER LOT_NUMBER, ORDER_INV_UOM ORDER_INV_UOM, ORDER_UOM1 ORDER_UOM1, ORDER_UOM2 ORDER_UOM2, ORGANIZATION_CODE ORGANIZATION_CODE, ORGANIZATION_ID ORGANIZATION_ID, REVISION REVISION, SHIP_QTY_UOM1 SHIP_QTY_UOM1, SHIP_QTY_UOM2 SHIP_QTY_UOM2, SPEC_HDR_TEXT_CODE SPEC_HDR_TEXT_CODE, SUBINVENTORY SUBINVENTORY from "GMD"."GMD_COA_HEADERS"

View Text - HTML Formatted

SELECT GMD_COA_ID GMD_COA_ID
, ORDER_ID ORDER_ID
, LINE_ID LINE_ID
, ORGN_CODE ORGN_CODE
, ORDER_NO ORDER_NO
, CUSTPO_NO CUSTPO_NO
, SHIPDATE SHIPDATE
, CUST_ID CUST_ID
, CUST_NO CUST_NO
, CUST_NAME CUST_NAME
, BOL_ID BOL_ID
, BOL_NO BOL_NO
, ITEM_ID ITEM_ID
, ITEM_NO ITEM_NO
, ITEM_DESC1 ITEM_DESC1
, WHSE_CODE WHSE_CODE
, WHSE_NAME WHSE_NAME
, LOT_ID LOT_ID
, LOT_NO LOT_NO
, LOT_DESC LOT_DESC
, SUBLOT_NO SUBLOT_NO
, ORDER_QTY1 ORDER_QTY1
, ORDER_UM1 ORDER_UM1
, ORDER_QTY2 ORDER_QTY2
, ORDER_UM2 ORDER_UM2
, SHIP_QTY1 SHIP_QTY1
, SHIP_QTY2 SHIP_QTY2
, REPORT_TITLE REPORT_TITLE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OPM_CUST_ID OPM_CUST_ID
, SESSION_ID SESSION_ID
, SHIP_UOM1 SHIP_UOM1
, SHIP_UOM2 SHIP_UOM2
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, ITEM_NUMBER ITEM_NUMBER
, LOT_DESCRIPTION LOT_DESCRIPTION
, LOT_NUMBER LOT_NUMBER
, ORDER_INV_UOM ORDER_INV_UOM
, ORDER_UOM1 ORDER_UOM1
, ORDER_UOM2 ORDER_UOM2
, ORGANIZATION_CODE ORGANIZATION_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, REVISION REVISION
, SHIP_QTY_UOM1 SHIP_QTY_UOM1
, SHIP_QTY_UOM2 SHIP_QTY_UOM2
, SPEC_HDR_TEXT_CODE SPEC_HDR_TEXT_CODE
, SUBINVENTORY SUBINVENTORY
FROM "GMD"."GMD_COA_HEADERS"