DBA Data[Home] [Help] [Dependency Information]

VIEW: GMD.GMD_COA_HEADERS#

Object Details
Object Name: GMD_COA_HEADERS#
Object Type: VIEW
Owner: GMD
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
GMD_COA_ID NUMBER (10) Yes
ORDER_ID NUMBER (10)
LINE_ID NUMBER (10)
ORGN_CODE VARCHAR2 (4)
ORDER_NO VARCHAR2 (32)
CUSTPO_NO VARCHAR2 (40)
SHIPDATE DATE

CUST_ID NUMBER (15)
CUST_NO VARCHAR2 (32)
CUST_NAME VARCHAR2 (360)
BOL_ID NUMBER (10)
BOL_NO VARCHAR2 (32)
ITEM_ID NUMBER (10)
ITEM_NO VARCHAR2 (32)
ITEM_DESC1 VARCHAR2 (70)
WHSE_CODE VARCHAR2 (4)
WHSE_NAME VARCHAR2 (40)
LOT_ID NUMBER (10)
LOT_NO VARCHAR2 (32)
LOT_DESC VARCHAR2 (40)
SUBLOT_NO VARCHAR2 (32)
ORDER_QTY1 NUMBER

ORDER_UM1 VARCHAR2 (4)
ORDER_QTY2 NUMBER

ORDER_UM2 VARCHAR2 (4)
SHIP_QTY1 NUMBER

SHIP_QTY2 NUMBER

REPORT_TITLE VARCHAR2 (4)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OPM_CUST_ID NUMBER (10)
SESSION_ID NUMBER

SHIP_UOM1 VARCHAR2 (4)
SHIP_UOM2 VARCHAR2 (4)
INVENTORY_ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
ITEM_NUMBER VARCHAR2 (240)
LOT_DESCRIPTION VARCHAR2 (240)
LOT_NUMBER VARCHAR2 (80)
ORDER_INV_UOM VARCHAR2 (3)
ORDER_UOM1 VARCHAR2 (3)
ORDER_UOM2 VARCHAR2 (3)
ORGANIZATION_CODE VARCHAR2 (3)
ORGANIZATION_ID NUMBER

REVISION VARCHAR2 (3)
SHIP_QTY_UOM1 VARCHAR2 (3)
SHIP_QTY_UOM2 VARCHAR2 (3)
SPEC_HDR_TEXT_CODE NUMBER (10)
SUBINVENTORY VARCHAR2 (10)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

GMD.GMD_COA_HEADERS# references the following:

SchemaGMD
TableGMD_COA_HEADERS
GMD.GMD_COA_HEADERS# is referenced by following:

SchemaAPPS
SynonymGMD_COA_HEADERS