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_BPOS_DTL

Object Details

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

PO_BPOS_DTL contains the detail information of items bought on a particular Blanket Purchase Order. It contains the blanket purchase order lines.
This table holds information that is captured from a Blanket Purchase Order, for example the warehouse from which the item will be shipped, the quality grade wanted, the quantity purchased, the shipping method and the shipper code, the terms and conditions for the purchase. This table is updated when Planned Purchase Orders entered in Oracle Purchasing are approved and transferred into OPM via the CPG_PURCHASING_INTERFACE table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_BPOS_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
PO_BPOS_DTL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TO_WHSE BPO_ID LINE_NO

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER	(10)	Yes	Unique surrogate key.
FROM_WHSE	VARCHAR2	(4)		Consignment warehouse. Fk to ic_whse_mst.
ITEM_ID	NUMBER	(10)	Yes	Fk to ic_item_mst.
GENERIC_ID	NUMBER	(10)		Fk to op_gnrc_itm.
ITEM_DESC	VARCHAR2	(70)	Yes	Free form item description.
CONTRACT_VALUE	NUMBER			Max money purchaseable on this line.
AMOUNT_PURCHASED	NUMBER			Amount purchased on this line.
CONTRACT_QTY	NUMBER			Max qty purchasable on this line.
TO_WHSE	VARCHAR2	(4)	Yes	Ship to whse. Fk to ic_whse_mst.
QTY_PURCHASED	NUMBER			Quantity purchased on this line.
STD_QTY	NUMBER		Yes	Standard release quantity.
RELEASE_INTERVAL	NUMBER		Yes	Standard time interval between releases.
ICPURCH_CLASS	VARCHAR2	(8)		Fk to ic_prch_cls.
BPO_STATUS	NUMBER	(5)	Yes	Bpo line status.
NET_PRICE	NUMBER		Yes	Unit price for item being purchased.
RECV_LOCT	VARCHAR2	(16)		Default receiving location.
RECVADDR_ID	NUMBER	(10)		Default receiving address.
RECV_DESC	VARCHAR2	(40)		Free form receiving description.
SHIP_MTHD	VARCHAR2	(4)		Fk to op_ship_mth.
SHIPPER_CODE	VARCHAR2	(4)		Fk to op_ship_mst.
SHIPVEND_ID	NUMBER	(10)	Yes	Fk to po_vend_mst.
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.
BPOHOLD_CODE	VARCHAR2	(4)		Fk to sy_reas_cds.
CANCELLATION_CODE	VARCHAR2	(4)		Fk to sy_reas_cds.
CLOSURE_CODE	VARCHAR2	(4)		Fk to sy_reas_cds.
FOB_CODE	VARCHAR2	(4)		Fk to op_tobc_mst.
VENDSO_NO	VARCHAR2	(32)		Vendors sales order number.
BUYER_CODE	VARCHAR2	(35)		Buyer on PO
PROJECT_NO	VARCHAR2	(16)		Not currently supported
MAX_RELS_QTY	NUMBER		Yes	Maximum quantity (in bpo um) that can be released on any one shipment.
MATCH_TYPE	NUMBER		Yes	Reserved for future use.
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
ITEM_UM	VARCHAR2	(4)	Yes	Unit of measure for quantity fields.
BPO_ID	NUMBER	(10)	Yes	Fk to po_bpos_hdr.
LINE_NO	NUMBER	(5)	Yes	Line number within document.
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 LINE_ID
,      FROM_WHSE
,      ITEM_ID
,      GENERIC_ID
,      ITEM_DESC
,      CONTRACT_VALUE
,      AMOUNT_PURCHASED
,      CONTRACT_QTY
,      TO_WHSE
,      QTY_PURCHASED
,      STD_QTY
,      RELEASE_INTERVAL
,      ICPURCH_CLASS
,      BPO_STATUS
,      NET_PRICE
,      RECV_LOCT
,      RECVADDR_ID
,      RECV_DESC
,      SHIP_MTHD
,      SHIPPER_CODE
,      SHIPVEND_ID
,      QC_GRADE_WANTED
,      FRTBILL_MTHD
,      TERMS_CODE
,      BPOHOLD_CODE
,      CANCELLATION_CODE
,      CLOSURE_CODE
,      FOB_CODE
,      VENDSO_NO
,      BUYER_CODE
,      PROJECT_NO
,      MAX_RELS_QTY
,      MATCH_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TEXT_CODE
,      TRANS_CNT
,      ITEM_UM
,      BPO_ID
,      LINE_NO
,      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_BPOS_DTL;

Dependencies

[top of page]

GML.PO_BPOS_DTL does not reference any database object

GML.PO_BPOS_DTL is referenced by following:

GML: PO_BPOS_DTL#