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.GML_RECV_ADJUST_ERRORS

Object Details

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

OPM Receipt adjustment errors are recorded in this table. Those rows which have no corresponding row in the Oracle table RCV_TRANSACTIONS are inserted into this table so that failed adjustments to Oracle Receipts can be tracked.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GML_RECV_ADJUST_ERRORS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RECV_ID LINE_ID SEQ_NO

Columns

Name	Datatype	Length	Mandatory	Comments
RECV_ID	NUMBER		Yes	recv_id from po_recv_hdr
LINE_ID	NUMBER		Yes	line_id from po_recv_dtl
SEQ_NO	NUMBER		Yes	sequence number for recv_id/line
RECV_QTY1	NUMBER			recv_qty1 from po_recv_dtl
OLD_RECV_QTY1	NUMBER			recv_qty1 from po_recv_dtl before adjustment
RECV_UM1	VARCHAR2	(4)		recv_um1 from po_recv_dtl
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
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
PROCESSED_IND	VARCHAR2	(1)		row processed 'N' or 'Y'
RETURN_IND	NUMBER			Indicates if this is a return (1 - for a return, 2 - for an adjustment to a return, 0 -Default)
RECV_STATUS	NUMBER			Status of the receipt (0: default, -1: if the receipt is voided)
VOID_RETURN_IND	NUMBER			Indicates if the return is voided (0 - default, 1 - if return is voided)

Query Text

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


SELECT RECV_ID
,      LINE_ID
,      SEQ_NO
,      RECV_QTY1
,      OLD_RECV_QTY1
,      RECV_UM1
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PROCESSED_IND
,      RETURN_IND
,      RECV_STATUS
,      VOID_RETURN_IND
FROM GML.GML_RECV_ADJUST_ERRORS;

Dependencies

[top of page]

GML.GML_RECV_ADJUST_ERRORS does not reference any database object

GML.GML_RECV_ADJUST_ERRORS is referenced by following:

APPS: GML_RECV_ADJUST_ERRORS