[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GML_GPOAO_DETAILS# |
|---|---|
| Object Type: | VIEW |
| Owner: | GML |
| Subobject Name: | |
| Status: | VALID |
| 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) |
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#;
GML
GML_GPOAO_DETAILS
APPS
GML_GPOAO_DETAILS
|
|
|
|