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_HST

Object Details

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

PO_RECV_HST maintains a detailed audit trail of quantity and price changes made to a receipt or return line. This table is used by the OPM Subsidiary Ledger to book the financial impact of Purchasing receipts and return activity. When the subsidiary ledger books the information, it obtains the GL distribution from the table PO_DIST_DTL. Values in several columns indicate whether the change is against a PO Receipt, a Stock Receipt, a PO Return or a Stock Return, as follows: 1) For a PO Receipt, the PO_% columns contain references to the PO in the OPM PO tables and the RECV_% columns contain references to the PO Receipt. 2) For a PO Return, the RECV_% columns contain the references to the Return in the PO_RTRN_HDR and _DTL tables. 3) For a Stock Receipt, all of the PO_% and RECV_% columns contain references to the Stock Receipt in PO_RECV_HDR and _DTL. 4) For a Stock Return, the PO_% columns contain zeroes and the RECV_% columns reference the original Stock Receipt.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RECV_HST_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECV_ID RECV_LINE_ID RECV_SEQ_NO SUB_EVENT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
REQUEST_ID	NUMBER	(15)		Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent who column
PROGRAM_ID	NUMBER	(15)		Concurrent who column
RECV_ID	NUMBER	(10)	Yes	This column may contain receipt id or a return id depending on whether this is a receipt or return: Recpt: fk to po_recv_hdr; Rtrn: fk to po_rtrn_hdr
RECV_LINE_ID	NUMBER	(10)	Yes	This column may contain a receipt or a return line number: Recpt: fk to po_recv_dtl; Rtrn: fk to po_rtrn_dtl
RECV_SEQ_NO	NUMBER	(5)	Yes	Sequential numbering of each activity recorded against the specific receipt line.
EXCHANGE_RATE	NUMBER		Yes	Receipt exchange rate.
MUL_DIV_SIGN	NUMBER	(5)	Yes	0 - multiply; 1 - divide
NET_QTY	NUMBER		Yes	Difference between the original quantity and the modified qty (adjusted quantity).
PRICE_UM	VARCHAR2	(4)	Yes	Fk to sy_uoms_mst.
NET_PRICE	NUMBER		Yes	Price of the line.
TO_WHSE	VARCHAR2	(4)	Yes	To warehouse .
GL_POSTED_IND	NUMBER	(5)	Yes	0 - not posted to subsidary ledger; 1- posted
PO_ID	NUMBER	(10)		Refers to the document that created the transaction: If a po: fk to po_ordr_hdr; If stock rcpt: fk to po_recv_hdr. For a stock return, the value of this column is zero.
PO_LINE_ID	NUMBER	(10)		Refers to the document line number that created the transaction: If po: fk to po_ordr_dtl; If stock receipt: fk to po_recv_dtl. For a stock return, the value of this column is zero.
SUB_EVENT_TYPE	NUMBER	(10)	Yes	Fk to gl_svnt_mst.
RECV_DATE	DATE		Yes	Date of the receipt as it appears on po_recv_hdr.
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
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.

Query Text

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


SELECT PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      RECV_ID
,      RECV_LINE_ID
,      RECV_SEQ_NO
,      EXCHANGE_RATE
,      MUL_DIV_SIGN
,      NET_QTY
,      PRICE_UM
,      NET_PRICE
,      TO_WHSE
,      GL_POSTED_IND
,      PO_ID
,      PO_LINE_ID
,      SUB_EVENT_TYPE
,      RECV_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GML.PO_RECV_HST;

Dependencies

[top of page]

GML.PO_RECV_HST does not reference any database object

GML.PO_RECV_HST is referenced by following:

APPS: PO_RECV_HST