Skip to content

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

VIEW: GML.GML_GPOAO_DETAILS#

Object Details
Object Name: GML_GPOAO_DETAILS#
Object Type: VIEW
Owner: GML
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RUN_ID NUMBER

ORDER_ID NUMBER

LINE_ID NUMBER

LINE_STATUS NUMBER

SHIP_STATUS NUMBER

SO_LINE_NO NUMBER

TRANS_CNT NUMBER

ACTUAL_SHIPDATE DATE

REQUESTED_SHIPDATE DATE

PROMISED_SHIPDATE DATE

SCHED_SHIPDATE DATE

ACTUAL_DLVDATE DATE

REQUIRED_DLVDATE DATE

HOLD_EXPIRATION DATE

EXPORT_DATE DATE

LINE_COMMENT VARCHAR2 (80)
SO_DETAIL_CATEGORY VARCHAR2 (30)
SO_DETAIL_ATTRIBUTE1 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE2 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE3 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE4 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE5 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE6 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE7 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE8 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE9 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE10 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE11 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE12 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE13 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE14 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE15 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE16 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE17 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE18 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE19 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE20 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE21 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE22 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE23 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE24 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE25 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE26 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE27 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE28 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE29 VARCHAR2 (240)
SO_DETAIL_ATTRIBUTE30 VARCHAR2 (240)
SHIP_METHOD_INT VARCHAR2 (4)
SHIP_METHOD_EXT1 VARCHAR2 (20)
SHIP_METHOD_EXT2 VARCHAR2 (20)
SHIP_METHOD_EXT3 VARCHAR2 (20)
SHIP_METHOD_EXT4 VARCHAR2 (20)
SHIP_METHOD_EXT5 VARCHAR2 (20)
BASE_CURRENCY_INT VARCHAR2 (4)
BASE_CURRENCY_EXT1 VARCHAR2 (20)
BASE_CURRENCY_EXT2 VARCHAR2 (20)
BASE_CURRENCY_EXT3 VARCHAR2 (20)
BASE_CURRENCY_EXT4 VARCHAR2 (20)
BASE_CURRENCY_EXT5 VARCHAR2 (20)
BILLING_CURRENCY_INT VARCHAR2 (4)
BILLING_CURRENCY_EXT1 VARCHAR2 (20)
BILLING_CURRENCY_EXT2 VARCHAR2 (20)
BILLING_CURRENCY_EXT3 VARCHAR2 (20)
BILLING_CURRENCY_EXT4 VARCHAR2 (20)
BILLING_CURRENCY_EXT5 VARCHAR2 (20)
HOLDREAS_CODE_INT VARCHAR2 (4)
HOLDREAS_CODE_EXT1 VARCHAR2 (20)
HOLDREAS_CODE_EXT2 VARCHAR2 (20)
HOLDREAS_CODE_EXT3 VARCHAR2 (20)
HOLDREAS_CODE_EXT4 VARCHAR2 (20)
HOLDREAS_CODE_EXT5 VARCHAR2 (20)
EXCHANGE_RATE NUMBER

SHIPTO_CUST_ID NUMBER

SHIPTO_CODE_INT VARCHAR2 (240)
SHIPTO_CODE_EXT1 VARCHAR2 (80)
SHIPTO_CODE_EXT2 VARCHAR2 (80)
SHIPTO_CODE_EXT3 VARCHAR2 (80)
SHIPTO_CODE_EXT4 VARCHAR2 (80)
SHIPTO_CODE_EXT5 VARCHAR2 (80)
SHIPTO_CUST_NAME VARCHAR2 (80)
SHIPTO_ADDR1 VARCHAR2 (70)
SHIPTO_ADDR2 VARCHAR2 (70)
SHIPTO_ADDR3 VARCHAR2 (70)
SHIPTO_ADDR4 VARCHAR2 (70)
SHIPTO_POSTAL_CODE VARCHAR2 (60)
SHIPTO_COUNTRY_CODE_INT VARCHAR2 (60)
SHIPTO_COUNTRY_CODE_EXT1 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT2 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT3 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT4 VARCHAR2 (80)
SHIPTO_COUNTRY_CODE_EXT5 VARCHAR2 (80)
SHIPTO_STATE_CODE_INT VARCHAR2 (60)
SHIPTO_STATE_CODE_EXT1 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT2 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT3 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT4 VARCHAR2 (80)
SHIPTO_STATE_CODE_EXT5 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_INT VARCHAR2 (60)
SHIPTO_PROVINCE_CODE_EXT1 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT2 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT3 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT4 VARCHAR2 (80)
SHIPTO_PROVINCE_CODE_EXT5 VARCHAR2 (80)
SHIPTO_COUNTY VARCHAR2 (60)
SHIPTO_LAST_NAME VARCHAR2 (50)
SHIPTO_FIRST_NAME VARCHAR2 (40)
SHIPTO_JOB_TITLE VARCHAR2 (50)
SHIPTO_AREA_CODE VARCHAR2 (10)
SHIPTO_TELEPHONE VARCHAR2 (60)
NET_WT NUMBER

TARE_WT NUMBER

PALLET_WT NUMBER

FRTBILL_WT NUMBER

SHIPWT_UM_INT VARCHAR2 (4)
SHIPWT_UM_EXT1 VARCHAR2 (20)
SHIPWT_UM_EXT2 VARCHAR2 (20)
SHIPWT_UM_EXT3 VARCHAR2 (20)
SHIPWT_UM_EXT4 VARCHAR2 (20)
SHIPWT_UM_EXT5 VARCHAR2 (20)
SHIP_VOLUME NUMBER

SHIPVOLUME_UM_INT VARCHAR2 (4)
SHIPVOLUME_UM_EXT1 VARCHAR2 (20)
SHIPVOLUME_UM_EXT2 VARCHAR2 (20)
SHIPVOLUME_UM_EXT3 VARCHAR2 (20)
SHIPVOLUME_UM_EXT4 VARCHAR2 (20)
SHIPVOLUME_UM_EXT5 VARCHAR2 (20)
ORDR_QTY1 NUMBER

SHIP_QTY1 NUMBER

ORDER_UM1_INT VARCHAR2 (4)
ORDER_UM1_EXT1 VARCHAR2 (20)
ORDER_UM1_EXT2 VARCHAR2 (20)
ORDER_UM1_EXT3 VARCHAR2 (20)
ORDER_UM1_EXT4 VARCHAR2 (20)
ORDER_UM1_EXT5 VARCHAR2 (20)
ORDR_QTY2 NUMBER

SHIP_QTY2 NUMBER

ORDER_UM2_INT VARCHAR2 (4)
ORDER_UM2_EXT1 VARCHAR2 (20)
ORDER_UM2_EXT2 VARCHAR2 (20)
ORDER_UM2_EXT3 VARCHAR2 (20)
ORDER_UM2_EXT4 VARCHAR2 (20)
ORDER_UM2_EXT5 VARCHAR2 (20)
ITEM_NO VARCHAR2 (32)
ITEM_DESC1 VARCHAR2 (70)
GENERIC_ITEM VARCHAR2 (32)
LINE_DESC VARCHAR2 (70)
TO_WHSE VARCHAR2 (4)
TO_WHSE_NAME VARCHAR2 (40)
PRICEREAS_CODE_INT VARCHAR2 (4)
PRICEREAS_CODE_EXT1 VARCHAR2 (20)
PRICEREAS_CODE_EXT2 VARCHAR2 (20)
PRICEREAS_CODE_EXT3 VARCHAR2 (20)
PRICEREAS_CODE_EXT4 VARCHAR2 (20)
PRICEREAS_CODE_EXT5 VARCHAR2 (20)
PRICEREAS_DESC VARCHAR2 (40)
BASE_PRICE NUMBER

NET_PRICE NUMBER

EXTENDED_PRICE NUMBER

LIST_PRICE NUMBER

SYSTEM_PRICE NUMBER

NET_TAX NUMBER

BILL_QTY NUMBER

FROM_WHSE VARCHAR2 (4)
FROM_WHSE_NAME VARCHAR2 (50)
FROM_WHSE_CONTACT VARCHAR2 (50)
FROM_WHSE_PHONE VARCHAR2 (60)
FROM_WHSE_ADDR1 VARCHAR2 (70)
FROM_WHSE_ADDR2 VARCHAR2 (70)
FROM_WHSE_ADDR3 VARCHAR2 (70)
FROM_WHSE_ADDR4 VARCHAR2 (70)
FROM_WHSE_POSTAL_CODE VARCHAR2 (60)
FROM_WHSE_COUNTRY_CODE_INT VARCHAR2 (60)
FROM_WHSE_COUNTRY_CODE_EXT1 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT2 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT3 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT4 VARCHAR2 (80)
FROM_WHSE_COUNTRY_CODE_EXT5 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_INT VARCHAR2 (60)
FROM_WHSE_STATE_CODE_EXT1 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT2 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT3 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT4 VARCHAR2 (80)
FROM_WHSE_STATE_CODE_EXT5 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_INT VARCHAR2 (60)
FROM_WHSE_PROVINCE_CODE_EXT1 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT2 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT3 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT4 VARCHAR2 (80)
FROM_WHSE_PROVINCE_CODE_EXT5 VARCHAR2 (80)
FROM_WHSE_COUNTY VARCHAR2 (60)
TRANSACTION_RECORD_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE NUMBER (15)
LINE_STATUS_CODE VARCHAR2 (16)
Query Text

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


SELECT RUN_ID
,      ORDER_ID
,      LINE_ID
,      LINE_STATUS
,      SHIP_STATUS
,      SO_LINE_NO
,      TRANS_CNT
,      ACTUAL_SHIPDATE
,      REQUESTED_SHIPDATE
,      PROMISED_SHIPDATE
,      SCHED_SHIPDATE
,      ACTUAL_DLVDATE
,      REQUIRED_DLVDATE
,      HOLD_EXPIRATION
,      EXPORT_DATE
,      LINE_COMMENT
,      SO_DETAIL_CATEGORY
,      SO_DETAIL_ATTRIBUTE1
,      SO_DETAIL_ATTRIBUTE2
,      SO_DETAIL_ATTRIBUTE3
,      SO_DETAIL_ATTRIBUTE4
,      SO_DETAIL_ATTRIBUTE5
,      SO_DETAIL_ATTRIBUTE6
,      SO_DETAIL_ATTRIBUTE7
,      SO_DETAIL_ATTRIBUTE8
,      SO_DETAIL_ATTRIBUTE9
,      SO_DETAIL_ATTRIBUTE10
,      SO_DETAIL_ATTRIBUTE11
,      SO_DETAIL_ATTRIBUTE12
,      SO_DETAIL_ATTRIBUTE13
,      SO_DETAIL_ATTRIBUTE14
,      SO_DETAIL_ATTRIBUTE15
,      SO_DETAIL_ATTRIBUTE16
,      SO_DETAIL_ATTRIBUTE17
,      SO_DETAIL_ATTRIBUTE18
,      SO_DETAIL_ATTRIBUTE19
,      SO_DETAIL_ATTRIBUTE20
,      SO_DETAIL_ATTRIBUTE21
,      SO_DETAIL_ATTRIBUTE22
,      SO_DETAIL_ATTRIBUTE23
,      SO_DETAIL_ATTRIBUTE24
,      SO_DETAIL_ATTRIBUTE25
,      SO_DETAIL_ATTRIBUTE26
,      SO_DETAIL_ATTRIBUTE27
,      SO_DETAIL_ATTRIBUTE28
,      SO_DETAIL_ATTRIBUTE29
,      SO_DETAIL_ATTRIBUTE30
,      SHIP_METHOD_INT
,      SHIP_METHOD_EXT1
,      SHIP_METHOD_EXT2
,      SHIP_METHOD_EXT3
,      SHIP_METHOD_EXT4
,      SHIP_METHOD_EXT5
,      BASE_CURRENCY_INT
,      BASE_CURRENCY_EXT1
,      BASE_CURRENCY_EXT2
,      BASE_CURRENCY_EXT3
,      BASE_CURRENCY_EXT4
,      BASE_CURRENCY_EXT5
,      BILLING_CURRENCY_INT
,      BILLING_CURRENCY_EXT1
,      BILLING_CURRENCY_EXT2
,      BILLING_CURRENCY_EXT3
,      BILLING_CURRENCY_EXT4
,      BILLING_CURRENCY_EXT5
,      HOLDREAS_CODE_INT
,      HOLDREAS_CODE_EXT1
,      HOLDREAS_CODE_EXT2
,      HOLDREAS_CODE_EXT3
,      HOLDREAS_CODE_EXT4
,      HOLDREAS_CODE_EXT5
,      EXCHANGE_RATE
,      SHIPTO_CUST_ID
,      SHIPTO_CODE_INT
,      SHIPTO_CODE_EXT1
,      SHIPTO_CODE_EXT2
,      SHIPTO_CODE_EXT3
,      SHIPTO_CODE_EXT4
,      SHIPTO_CODE_EXT5
,      SHIPTO_CUST_NAME
,      SHIPTO_ADDR1
,      SHIPTO_ADDR2
,      SHIPTO_ADDR3
,      SHIPTO_ADDR4
,      SHIPTO_POSTAL_CODE
,      SHIPTO_COUNTRY_CODE_INT
,      SHIPTO_COUNTRY_CODE_EXT1
,      SHIPTO_COUNTRY_CODE_EXT2
,      SHIPTO_COUNTRY_CODE_EXT3
,      SHIPTO_COUNTRY_CODE_EXT4
,      SHIPTO_COUNTRY_CODE_EXT5
,      SHIPTO_STATE_CODE_INT
,      SHIPTO_STATE_CODE_EXT1
,      SHIPTO_STATE_CODE_EXT2
,      SHIPTO_STATE_CODE_EXT3
,      SHIPTO_STATE_CODE_EXT4
,      SHIPTO_STATE_CODE_EXT5
,      SHIPTO_PROVINCE_CODE_INT
,      SHIPTO_PROVINCE_CODE_EXT1
,      SHIPTO_PROVINCE_CODE_EXT2
,      SHIPTO_PROVINCE_CODE_EXT3
,      SHIPTO_PROVINCE_CODE_EXT4
,      SHIPTO_PROVINCE_CODE_EXT5
,      SHIPTO_COUNTY
,      SHIPTO_LAST_NAME
,      SHIPTO_FIRST_NAME
,      SHIPTO_JOB_TITLE
,      SHIPTO_AREA_CODE
,      SHIPTO_TELEPHONE
,      NET_WT
,      TARE_WT
,      PALLET_WT
,      FRTBILL_WT
,      SHIPWT_UM_INT
,      SHIPWT_UM_EXT1
,      SHIPWT_UM_EXT2
,      SHIPWT_UM_EXT3
,      SHIPWT_UM_EXT4
,      SHIPWT_UM_EXT5
,      SHIP_VOLUME
,      SHIPVOLUME_UM_INT
,      SHIPVOLUME_UM_EXT1
,      SHIPVOLUME_UM_EXT2
,      SHIPVOLUME_UM_EXT3
,      SHIPVOLUME_UM_EXT4
,      SHIPVOLUME_UM_EXT5
,      ORDR_QTY1
,      SHIP_QTY1
,      ORDER_UM1_INT
,      ORDER_UM1_EXT1
,      ORDER_UM1_EXT2
,      ORDER_UM1_EXT3
,      ORDER_UM1_EXT4
,      ORDER_UM1_EXT5
,      ORDR_QTY2
,      SHIP_QTY2
,      ORDER_UM2_INT
,      ORDER_UM2_EXT1
,      ORDER_UM2_EXT2
,      ORDER_UM2_EXT3
,      ORDER_UM2_EXT4
,      ORDER_UM2_EXT5
,      ITEM_NO
,      ITEM_DESC1
,      GENERIC_ITEM
,      LINE_DESC
,      TO_WHSE
,      TO_WHSE_NAME
,      PRICEREAS_CODE_INT
,      PRICEREAS_CODE_EXT1
,      PRICEREAS_CODE_EXT2
,      PRICEREAS_CODE_EXT3
,      PRICEREAS_CODE_EXT4
,      PRICEREAS_CODE_EXT5
,      PRICEREAS_DESC
,      BASE_PRICE
,      NET_PRICE
,      EXTENDED_PRICE
,      LIST_PRICE
,      SYSTEM_PRICE
,      NET_TAX
,      BILL_QTY
,      FROM_WHSE
,      FROM_WHSE_NAME
,      FROM_WHSE_CONTACT
,      FROM_WHSE_PHONE
,      FROM_WHSE_ADDR1
,      FROM_WHSE_ADDR2
,      FROM_WHSE_ADDR3
,      FROM_WHSE_ADDR4
,      FROM_WHSE_POSTAL_CODE
,      FROM_WHSE_COUNTRY_CODE_INT
,      FROM_WHSE_COUNTRY_CODE_EXT1
,      FROM_WHSE_COUNTRY_CODE_EXT2
,      FROM_WHSE_COUNTRY_CODE_EXT3
,      FROM_WHSE_COUNTRY_CODE_EXT4
,      FROM_WHSE_COUNTRY_CODE_EXT5
,      FROM_WHSE_STATE_CODE_INT
,      FROM_WHSE_STATE_CODE_EXT1
,      FROM_WHSE_STATE_CODE_EXT2
,      FROM_WHSE_STATE_CODE_EXT3
,      FROM_WHSE_STATE_CODE_EXT4
,      FROM_WHSE_STATE_CODE_EXT5
,      FROM_WHSE_PROVINCE_CODE_INT
,      FROM_WHSE_PROVINCE_CODE_EXT1
,      FROM_WHSE_PROVINCE_CODE_EXT2
,      FROM_WHSE_PROVINCE_CODE_EXT3
,      FROM_WHSE_PROVINCE_CODE_EXT4
,      FROM_WHSE_PROVINCE_CODE_EXT5
,      FROM_WHSE_COUNTY
,      TRANSACTION_RECORD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LINE_STATUS_CODE
FROM GML.GML_GPOAO_DETAILS#;

Dependencies

[top of page]

GML.GML_GPOAO_DETAILS# references the following:

SchemaGML
TableGML_GPOAO_DETAILS
GML.GML_GPOAO_DETAILS# is referenced by following:

SchemaAPPS
SynonymGML_GPOAO_DETAILS