eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: GML.OP_PRSL_DTL#

Object Details

Object Name:	OP_PRSL_DTL#
Object Type:	VIEW
Owner:	GML
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
HOLD_EXPIRATION	DATE
PRESALES_ORDLINE_ID	NUMBER	(10)	Yes
PRESALES_ORDLINE_NO	NUMBER	(5)	Yes
SALESPKG_ID	NUMBER	(10)
ITEM_ID	NUMBER	(10)	Yes
GENERIC_ID	NUMBER	(10)
DEBARKATION_PORT	VARCHAR2	(8)
EMBARKATION_PORT	VARCHAR2	(8)
REMIT_TO_LOCKBOX	VARCHAR2	(8)
PRESALES_ORD_ID	NUMBER	(10)	Yes
BILLCUST_ID	NUMBER	(15)
SHIPCUST_ID	NUMBER	(15)
CONSIGNEE_ID	NUMBER	(10)
ULTIMATE_SHIPCUST_ID	NUMBER	(15)
SOLDTOCUST_ID	NUMBER	(15)
CUSTTRADE_CLASS	VARCHAR2	(8)
SHIPADDR_ID	NUMBER	(10)
CONTACT_ID	NUMBER	(10)
PROFORMA_INVOICE_REQD	NUMBER	(5)
SHIP_MTHD	VARCHAR2	(4)
SHIPPER_CODE	VARCHAR2	(4)
SLSREP_CODE	VARCHAR2	(8)
COMMISSION_CODE	VARCHAR2	(8)
BILLING_CURRENCY	VARCHAR2	(4)
TO_WHSE	VARCHAR2	(4)
FROM_WHSE	VARCHAR2	(4)
FOB_CODE	VARCHAR2	(4)
TERMS_CODE	VARCHAR2	(4)
FRTBILL_MTHD	VARCHAR2	(4)
COA_REQUIRED	NUMBER	(5)
BACKORDER_IND	NUMBER	(5)
MINSHIP_PCT	NUMBER
MAXSHIP_PCT	NUMBER
HOLDREAS_CODE	VARCHAR2	(4)
LINE_DESC	VARCHAR2	(70)	Yes
LINE_COMMENT	VARCHAR2	(70)
ORDER_QTY1	NUMBER		Yes
ORDER_QTY2	NUMBER
ORDER_UM1	VARCHAR2	(4)	Yes
ORDER_UM2	VARCHAR2	(4)
INVENTORY_QTY	NUMBER		Yes
QC_GRADE_WANTED	VARCHAR2	(4)
SPECMATCH_REQD	NUMBER	(5)
STATUS_IND	NUMBER	(5)	Yes
TRANS_CNT	NUMBER	(10)
CUSTPO_NO	VARCHAR2	(40)
CUST_CONTRACT_NO	VARCHAR2	(40)
EXCHANGE_RATE	NUMBER		Yes
MUL_DIV_SIGN	NUMBER	(5)	Yes
MIN_CLOSE_PERCENT	NUMBER
LINE_MAX_VALUE	NUMBER
LINE_MAX_QTY	NUMBER
LINE_MIN_VALUE	NUMBER
LINE_MIN_QTY	NUMBER
LINE_RELEASE_VALUE	NUMBER
LINE_RELEASE_QTY	NUMBER
LINE_OPEN_VALUE	NUMBER
LINE_OPEN_QTY	NUMBER
LINE_SHIP_VALUE	NUMBER
LINE_SHIP_QTY	NUMBER
LINE_AVAIL_VALUE	NUMBER
LINE_AVAIL_QTY	NUMBER
LINE_SCHED_VALUE	NUMBER
LINE_SCHED_QTY	NUMBER
RELEASE_MAX_VALUE	NUMBER
RELEASE_MAX_QTY	NUMBER
RELEASE_MIN_VALUE	NUMBER
RELEASE_MIN_QTY	NUMBER
TEXT_CODE	NUMBER	(10)
DELETE_MARK	NUMBER	(5)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ATTRIBUTE1	VARCHAR2	(240)
ATTRIBUTE2	VARCHAR2	(240)
ATTRIBUTE3	VARCHAR2	(240)
ATTRIBUTE4	VARCHAR2	(240)
ATTRIBUTE5	VARCHAR2	(240)
ATTRIBUTE6	VARCHAR2	(240)
ATTRIBUTE7	VARCHAR2	(240)
ATTRIBUTE8	VARCHAR2	(240)
ATTRIBUTE9	VARCHAR2	(240)
ATTRIBUTE10	VARCHAR2	(240)
ATTRIBUTE11	VARCHAR2	(240)
ATTRIBUTE12	VARCHAR2	(240)
ATTRIBUTE13	VARCHAR2	(240)
ATTRIBUTE14	VARCHAR2	(240)
ATTRIBUTE15	VARCHAR2	(240)
ATTRIBUTE16	VARCHAR2	(240)
ATTRIBUTE17	VARCHAR2	(240)
ATTRIBUTE18	VARCHAR2	(240)
ATTRIBUTE19	VARCHAR2	(240)
ATTRIBUTE20	VARCHAR2	(240)
ATTRIBUTE21	VARCHAR2	(240)
ATTRIBUTE22	VARCHAR2	(240)
ATTRIBUTE23	VARCHAR2	(240)
ATTRIBUTE24	VARCHAR2	(240)
ATTRIBUTE25	VARCHAR2	(240)
ATTRIBUTE26	VARCHAR2	(240)
ATTRIBUTE27	VARCHAR2	(240)
ATTRIBUTE28	VARCHAR2	(240)
ATTRIBUTE29	VARCHAR2	(240)
ATTRIBUTE30	VARCHAR2	(240)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
UPGRADE_FLAG	VARCHAR2	(2)
UPGRADE_DATE	DATE
OPM_SHIPCUST_ID	NUMBER	(10)
OPM_BILLCUST_ID	NUMBER	(10)
OPM_SOLDTOCUST_ID	NUMBER	(10)
OPM_ULTIMATE_SHIPCUST_ID	NUMBER	(10)

Query Text

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


SELECT HOLD_EXPIRATION
,      PRESALES_ORDLINE_ID
,      PRESALES_ORDLINE_NO
,      SALESPKG_ID
,      ITEM_ID
,      GENERIC_ID
,      DEBARKATION_PORT
,      EMBARKATION_PORT
,      REMIT_TO_LOCKBOX
,      PRESALES_ORD_ID
,      BILLCUST_ID
,      SHIPCUST_ID
,      CONSIGNEE_ID
,      ULTIMATE_SHIPCUST_ID
,      SOLDTOCUST_ID
,      CUSTTRADE_CLASS
,      SHIPADDR_ID
,      CONTACT_ID
,      PROFORMA_INVOICE_REQD
,      SHIP_MTHD
,      SHIPPER_CODE
,      SLSREP_CODE
,      COMMISSION_CODE
,      BILLING_CURRENCY
,      TO_WHSE
,      FROM_WHSE
,      FOB_CODE
,      TERMS_CODE
,      FRTBILL_MTHD
,      COA_REQUIRED
,      BACKORDER_IND
,      MINSHIP_PCT
,      MAXSHIP_PCT
,      HOLDREAS_CODE
,      LINE_DESC
,      LINE_COMMENT
,      ORDER_QTY1
,      ORDER_QTY2
,      ORDER_UM1
,      ORDER_UM2
,      INVENTORY_QTY
,      QC_GRADE_WANTED
,      SPECMATCH_REQD
,      STATUS_IND
,      TRANS_CNT
,      CUSTPO_NO
,      CUST_CONTRACT_NO
,      EXCHANGE_RATE
,      MUL_DIV_SIGN
,      MIN_CLOSE_PERCENT
,      LINE_MAX_VALUE
,      LINE_MAX_QTY
,      LINE_MIN_VALUE
,      LINE_MIN_QTY
,      LINE_RELEASE_VALUE
,      LINE_RELEASE_QTY
,      LINE_OPEN_VALUE
,      LINE_OPEN_QTY
,      LINE_SHIP_VALUE
,      LINE_SHIP_QTY
,      LINE_AVAIL_VALUE
,      LINE_AVAIL_QTY
,      LINE_SCHED_VALUE
,      LINE_SCHED_QTY
,      RELEASE_MAX_VALUE
,      RELEASE_MAX_QTY
,      RELEASE_MIN_VALUE
,      RELEASE_MIN_QTY
,      TEXT_CODE
,      DELETE_MARK
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      UPGRADE_FLAG
,      UPGRADE_DATE
,      OPM_SHIPCUST_ID
,      OPM_BILLCUST_ID
,      OPM_SOLDTOCUST_ID
,      OPM_ULTIMATE_SHIPCUST_ID
FROM GML.OP_PRSL_DTL#;

Dependencies

[top of page]

GML.OP_PRSL_DTL# references the following:

GML: OP_PRSL_DTL

GML.OP_PRSL_DTL# is referenced by following:

APPS: OP_PRSL_DTL