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: PO.RCV_SERIALS_INTERFACE

Object Details

Object Name:	RCV_SERIALS_INTERFACE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_SERIALS_INTERFACE
Subobject Name:
Status:	VALID

RCV_SERIALS_INTERFACE holds temporary serial number transaction
records for a parent record in RCV_TRANSACTIONS_INTERFACE.
Data in the RCV_TRANSACTIONS_INTERFACE table will eventually reside in RCV_SERIAL_TRANSACTIONS after they are processed by the transaction processor.
.
It is possible to have child records in this table without a parent
record due to the automatic save feature in the Lot Entry and Serial
Numbers forms. The receiving transaction processor deletes orphan
rows during normal processing.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_SERIALS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INTERFACE_TRANSACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_TRANSACTION_ID	NUMBER		Yes	Interface transaction unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
TRANSACTION_DATE	DATE		Yes	Serial transaction date
FM_SERIAL_NUM	VARCHAR2	(30)	Yes	Start of serial number range
TO_SERIAL_NUM	VARCHAR2	(30)		End of serial number range
SERIAL_PREFIX	VARCHAR2	(30)		Total serial numbers entered
LOT_NUM	VARCHAR2	(80)		Lot number that serial numbers belong to
VENDOR_SERIAL_NUM	VARCHAR2	(30)		Not currently used
VENDOR_LOT_NUM	VARCHAR2	(30)		Not currently used
ITEM_ID	NUMBER			Item that serial number is assigned to
ORGANIZATION_ID	NUMBER			Organization that serial number is assigned to

Query Text

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


SELECT INTERFACE_TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_DATE
,      FM_SERIAL_NUM
,      TO_SERIAL_NUM
,      SERIAL_PREFIX
,      LOT_NUM
,      VENDOR_SERIAL_NUM
,      VENDOR_LOT_NUM
,      ITEM_ID
,      ORGANIZATION_ID
FROM PO.RCV_SERIALS_INTERFACE;

Dependencies

[top of page]

PO.RCV_SERIALS_INTERFACE does not reference any database object

PO.RCV_SERIALS_INTERFACE is referenced by following:

PO: RCV_SERIALS_INTERFACE#