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_RECV_DTL

Object Details

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

PO_RECV_DTL table tracks the receipts made against a purchase order.This table has entries for every line that is received against the line in a PO along with the received quantity, receive location, shipping method and the shipper code.
Information in this table is transferred to Oracle Purchasing so that detailed receiving information is available in that application, and specifically, for matching invoices entered in Oracle Payables (and generating automatic invoices). The Receiving Open Interface in Oracle Purchasing is used to create receiving transactions in Oracle Purchasing when receipts are saved in OPM.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RECV_DTLI1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECV_ID LINE_NO
PO_RECV_DTL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
PO_RECV_DTLI2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POLINE_ID
PO_RECV_DTLI3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECV_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER	(10)	Yes	Surrogate key to the receipt line number.
RECV_ID	NUMBER	(10)	Yes	Surrogate key to the receipt.
LINE_NO	NUMBER	(5)	Yes	Receipt line number.
PO_ID	NUMBER	(10)		Surrogate key to the purchase order received against.
POLINE_ID	NUMBER	(10)		Surrogate key to the purchase order linereceived against.
RECV_QTY1	NUMBER		Yes	Quantity received (in uom1).
RECV_QTY2	NUMBER			Quantity received (in uom 2).
RECV_UM1	VARCHAR2	(4)	Yes	Unit of measure 1.
RECV_UM2	VARCHAR2	(4)		Unit of measure 2.
PORECV_QTY1	NUMBER			Quantity received (in po uom 1).
PORECV_QTY2	NUMBER			Quantity received (in po uom 2).
RECVADDR_ID	NUMBER	(10)		Fk to sy_addr_mst
SHIPPER_CODE	VARCHAR2	(4)		Fk to op_ship_mst.
SHIP_MTHD	VARCHAR2	(4)		Fk to op_ship_mth.
TO_WHSE	VARCHAR2	(4)	Yes	Fk to ic_whse_mst.
FROM_WHSE	VARCHAR2	(4)		Fk to ic_whse_mst.
RECV_LOCT	VARCHAR2	(16)		Fk to ic_loct_mst.
RECV_DESC	VARCHAR2	(40)		User entered description.
FRTBILL_MTHD	VARCHAR2	(4)		Fk to op_frgt_mth.
FOB_CODE	VARCHAR2	(4)		Fk to op_fobc_mst.
RECV_DATE	DATE		Yes	Date of the receipt.
RECV_STATUS	NUMBER	(5)	Yes	Status of the receipt: 0 - pending; 20 - completed
ALLOC_IND	NUMBER	(5)	Yes	Indicates whether the lots have been fully allocated to the line: 0 - not allocated; 1 - fully allocated
EXTENDED_PRICE	NUMBER		Yes	Price x received quantity
ITEM_ID	NUMBER	(10)	Yes	Surrogate key to the item received.
NET_PRICE	NUMBER		Yes	Price in price_um
PRICE_UM	VARCHAR2	(4)	Yes	Price uom.
RETURN_IND	NUMBER	(5)	Yes	1=a return has been issued against thisreceipt.
SHIPVEND_ID	NUMBER	(10)		Fk to po_vend_mst.
VENDSO_NO	VARCHAR2	(32)		The vendor sales order number.
GL_POSTED_IND	NUMBER	(5)	Yes	Indicates whether the information has been posted to the gl. 0 - not posted; 1 - posted
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
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
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module

Query Text

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


SELECT LINE_ID
,      RECV_ID
,      LINE_NO
,      PO_ID
,      POLINE_ID
,      RECV_QTY1
,      RECV_QTY2
,      RECV_UM1
,      RECV_UM2
,      PORECV_QTY1
,      PORECV_QTY2
,      RECVADDR_ID
,      SHIPPER_CODE
,      SHIP_MTHD
,      TO_WHSE
,      FROM_WHSE
,      RECV_LOCT
,      RECV_DESC
,      FRTBILL_MTHD
,      FOB_CODE
,      RECV_DATE
,      RECV_STATUS
,      ALLOC_IND
,      EXTENDED_PRICE
,      ITEM_ID
,      NET_PRICE
,      PRICE_UM
,      RETURN_IND
,      SHIPVEND_ID
,      VENDSO_NO
,      GL_POSTED_IND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      TEXT_CODE
FROM GML.PO_RECV_DTL;

Dependencies

[top of page]

GML.PO_RECV_DTL does not reference any database object

GML.PO_RECV_DTL is referenced by following:

APPS: PO_RECV_DTL