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]

TABLE: GML.PO_ORDR_HDR

Object Details

Object Name:	PO_ORDR_HDR
Object Type:	TABLE
Owner:	GML
FND Design Data:	GML.PO_ORDR_HDR
Subobject Name:
Status:	VALID

PO_ORDR_HDR holds the main header information of your Purchase order documents. This is the header block of the Purchase order transaction in OPM. Every purchasing document except blanket purchase orders has a row in this table. Purchase orders are entered in the Oracle Purchasing application and transferred to this table via the CPG_PURCHASING_INTERFACE table and a synchronization program run under the concurrent manager.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_ORDR_HDR_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_ID
PO_ORDR_HDR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGN_CODE PO_NO

Columns

Name	Datatype	Length	Mandatory	Comments
ACCT_MAP_DATE	DATE			Date the gl acct dist was created
PO_ID	NUMBER	(10)	Yes	Physical key.
ORGN_CODE	VARCHAR2	(4)	Yes	In sy_orgn_mst.
BPO_ID	NUMBER	(10)		Fk to po_bpos_hdr.
FRTBILL_MTHD	VARCHAR2	(4)		In op_frgt_mth. Optional.
BPO_RELEASE_NO	NUMBER			User relevant bpo release number.
PO_TYPE	NUMBER	(5)	Yes	In sy_type_mst.
PAYVEND_ID	NUMBER	(10)	Yes	Billing vendor id in po_vend_mst.
SHIPVEND_ID	NUMBER	(10)	Yes	Shipping vendor. Default for line item.
RECVADDR_ID	NUMBER	(10)		Receive location address. Default for line.
SHIPPER_CODE	VARCHAR2	(4)		Default anticipated shipper (op_ship_mst).
RECV_DESC	VARCHAR2	(40)		Free form ship to destination.
FROM_WHSE	VARCHAR2	(4)		For intra-company transfers.
TO_WHSE	VARCHAR2	(4)	Yes	Default. Anticipated receiving warehouse.
RECV_LOCT	VARCHAR2	(16)		Default. Anticipated receiving location.
SHIP_MTHD	VARCHAR2	(4)		Default. Anticipated ship method.
PO_NO	VARCHAR2	(32)	Yes	Logical key. May have orgn_code pre-pend.
PURCHASE_EXCHANGE_RATE	NUMBER		Yes	Home/billing_currency exchange rate.
MUL_DIV_SIGN	NUMBER	(5)	Yes	0 - multiply exhange rate; 1 - divide exchange rate
BILLING_CURRENCY	VARCHAR2	(4)	Yes	Currency in which to pay invoice.
CURRENCY_BGHT_FWD	NUMBER	(5)	Yes	Currency brought forward flag.
TERMS_CODE	VARCHAR2	(4)		Default from bill vendor in op_term_mst.
PO_STATUS	NUMBER	(5)	Yes	0=not closed; 20=closed.
POHOLD_CODE	VARCHAR2	(4)		Fk to sy_reas_mst.
CANCELLATION_CODE	VARCHAR2	(4)		Fk to sy_reas_mst.
FOB_CODE	VARCHAR2	(4)		In op_fobc_mst. Default from ship vendor.
BUYER_CODE	VARCHAR2	(35)		Buyer on PO
ICPURCH_CLASS	VARCHAR2	(8)		Fk to ic_prch_cls.
VENDSO_NO	VARCHAR2	(32)		Vendor sales order number.
PROJECT_NO	VARCHAR2	(16)		Not currently supported
PO_DATE	DATE		Yes	User defined date of purchase order.
REQUESTED_DLVDATE	DATE		Yes	Requested delivery date.
SCHED_SHIPDATE	DATE		Yes	Scheduled ship date.
REQUIRED_DLVDATE	DATE		Yes	Required delivery date.
AGREED_DLVDATE	DATE		Yes	Agreed delivery date.
DATE_PRINTED	DATE		Yes	Date printed onto form for vendor.
EXPEDITE_DATE	DATE			Not recvd by date/tickler date for rpt.
REVISION_COUNT	NUMBER	(5)		Number of times revised.
IN_USE	NUMBER	(10)		Not currently used
PRINT_COUNT	NUMBER	(5)		Number of times printed.
EXPORTED_DATE	DATE			Date the transaction was exported to oracle financials.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE30	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE21	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE22	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE23	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE24	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE25	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE26	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE27	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE28	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE29	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
PURCH_CATEGORY_ID	NUMBER			Category Id for PURCH_CLASS

Query Text

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


SELECT ACCT_MAP_DATE
,      PO_ID
,      ORGN_CODE
,      BPO_ID
,      FRTBILL_MTHD
,      BPO_RELEASE_NO
,      PO_TYPE
,      PAYVEND_ID
,      SHIPVEND_ID
,      RECVADDR_ID
,      SHIPPER_CODE
,      RECV_DESC
,      FROM_WHSE
,      TO_WHSE
,      RECV_LOCT
,      SHIP_MTHD
,      PO_NO
,      PURCHASE_EXCHANGE_RATE
,      MUL_DIV_SIGN
,      BILLING_CURRENCY
,      CURRENCY_BGHT_FWD
,      TERMS_CODE
,      PO_STATUS
,      POHOLD_CODE
,      CANCELLATION_CODE
,      FOB_CODE
,      BUYER_CODE
,      ICPURCH_CLASS
,      VENDSO_NO
,      PROJECT_NO
,      PO_DATE
,      REQUESTED_DLVDATE
,      SCHED_SHIPDATE
,      REQUIRED_DLVDATE
,      AGREED_DLVDATE
,      DATE_PRINTED
,      EXPEDITE_DATE
,      REVISION_COUNT
,      IN_USE
,      PRINT_COUNT
,      EXPORTED_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELETE_MARK
,      TEXT_CODE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE30
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE12
,      ATTRIBUTE_CATEGORY
,      PURCH_CATEGORY_ID
FROM GML.PO_ORDR_HDR;

Dependencies

[top of page]

GML.PO_ORDR_HDR does not reference any database object

GML.PO_ORDR_HDR is referenced by following:

GML: PO_ORDR_HDR#