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_DTL

Object Details

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

PO_ORDR_DTL holds the details of your purchase order document. It stores various information such as ordered quantity, received quantity , the dual uoms of the item, freight details, terms and conditions of the PO , the promised delivery dates and requested delivery dates. 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_DTL	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
PO_ORDR_DTL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PO_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
PO_ID	NUMBER	(10)	Yes	In po_ordr_hdr.
ACCT_MAP_IND	NUMBER	(5)		0=gl. acct dist are not populated in po_dist_dist, 1=gl acct. dist are populated in po_dist_dtl
LINE_ID	NUMBER	(10)	Yes	Surrogate for access from other tables.
LINE_NO	NUMBER	(5)	Yes	Duplicates on partial recvs allowed.
BPO_LINE_ID	NUMBER	(10)		Fk to po_bpos_dtl.
APINV_LINE_ID	NUMBER	(10)		Reserved for future use.
ITEM_ID	NUMBER	(10)	Yes	In ic_item_mst.
GENERIC_ID	NUMBER	(10)		If >0, in op_gnrc_item.
ITEM_DESC	VARCHAR2	(70)	Yes	Free form item description.
ICPURCH_CLASS	VARCHAR2	(8)		Fk to ic_prch_cls.
PO_STATUS	NUMBER	(5)	Yes	Determines the status of a purchase order: 0 - open; 1 - cancelled; 2 - closed
ORDER_QTY1	NUMBER		Yes	Quantity ordered. Original line only.
ORDER_QTY2	NUMBER			Quantity ordered. Original line only.
ORDER_UM1	VARCHAR2	(4)	Yes	Uom of order_qty1.
ORDER_UM2	VARCHAR2	(4)		Used if order_qty2 >0.
RECEIVED_QTY1	NUMBER			Total of receipts in order_um1.
RECEIVED_QTY2	NUMBER			Total of receipts in order_um2.
NET_PRICE	NUMBER		Yes	Price per price_um.
EXTENDED_PRICE	NUMBER		Yes	Total price for line.
PRICE_UM	VARCHAR2	(4)	Yes	Uom for pricing purposes.
FROM_WHSE	VARCHAR2	(4)		For intra-company transfers.
TO_WHSE	VARCHAR2	(4)	Yes	Anticipated receiving warehouse.
RECV_LOCT	VARCHAR2	(16)		Anticipated receiving location.
RECVADDR_ID	NUMBER	(10)		In sy_addr_mst. Usually warehouse address.
RECV_DESC	VARCHAR2	(40)		Free form shipment destination.
SHIP_MTHD	VARCHAR2	(4)		Anticipated ship method (op_ship_mth).
SHIPPER_CODE	VARCHAR2	(4)		Anticipated shipper (op_ship_mst).
SHIPVEND_ID	NUMBER	(10)	Yes	Shipping vendor id.
QC_GRADE_WANTED	VARCHAR2	(4)		Necessary quality grade.
FRTBILL_MTHD	VARCHAR2	(4)		Fk to op_frgt_mth.
TERMS_CODE	VARCHAR2	(4)		Fk to op_term_mst.
POHOLD_CODE	VARCHAR2	(4)		Fk to sy_reas_cds.
CANCELLATION_CODE	VARCHAR2	(4)		Fk to sy_reas_cds.
FOB_CODE	VARCHAR2	(4)		Fk to op_fobc_mst.
VENDSO_NO	VARCHAR2	(32)		Vendor sales order number.
BUYER_CODE	VARCHAR2	(35)		Buyer on PO
PROJECT_NO	VARCHAR2	(16)		Not currently supported
AGREED_DLVDATE	DATE		Yes	Agreed delivery date.
EXPEDITE_DATE	DATE			Date expedited.
REQUESTED_DLVDATE	DATE		Yes	Requested delivery date.
REQUIRED_DLVDATE	DATE		Yes	Required delivery date.
SCHED_SHIPDATE	DATE		Yes	Scheduled ship date.
MATCH_TYPE	NUMBER		Yes	Reserved for future use
EXPORTED_DATE	DATE			Date that the transaction was exported to oracle finanacials. Defaults to sy$mindate.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT	NUMBER	(10)		Not currently used
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
ATTRIBUTE12	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
ATTRIBUTE30	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 PO_ID
,      ACCT_MAP_IND
,      LINE_ID
,      LINE_NO
,      BPO_LINE_ID
,      APINV_LINE_ID
,      ITEM_ID
,      GENERIC_ID
,      ITEM_DESC
,      ICPURCH_CLASS
,      PO_STATUS
,      ORDER_QTY1
,      ORDER_QTY2
,      ORDER_UM1
,      ORDER_UM2
,      RECEIVED_QTY1
,      RECEIVED_QTY2
,      NET_PRICE
,      EXTENDED_PRICE
,      PRICE_UM
,      FROM_WHSE
,      TO_WHSE
,      RECV_LOCT
,      RECVADDR_ID
,      RECV_DESC
,      SHIP_MTHD
,      SHIPPER_CODE
,      SHIPVEND_ID
,      QC_GRADE_WANTED
,      FRTBILL_MTHD
,      TERMS_CODE
,      POHOLD_CODE
,      CANCELLATION_CODE
,      FOB_CODE
,      VENDSO_NO
,      BUYER_CODE
,      PROJECT_NO
,      AGREED_DLVDATE
,      EXPEDITE_DATE
,      REQUESTED_DLVDATE
,      REQUIRED_DLVDATE
,      SCHED_SHIPDATE
,      MATCH_TYPE
,      EXPORTED_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TEXT_CODE
,      TRANS_CNT
,      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
,      PURCH_CATEGORY_ID
FROM GML.PO_ORDR_DTL;

Dependencies

[top of page]

GML.PO_ORDR_DTL does not reference any database object

GML.PO_ORDR_DTL is referenced by following:

APPS: PO_ORDR_DTL