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_GAPLESS_INVOICE_NUMBERS

Object Details

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

RCV_GAPLESS_INVOICE_NUMBERS hold the list of existing gapless invoice numbers that have already been created. The combination of PREFIX + BUYING_COMPANY_CODE + SELLING_COMPANY_CODE needs to be unique. The column NEXT_SEQUENCE_NUMBER is the next sequence number expected.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_GAPLESS_INVOICE_NUMBERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PREFIX BUYING_COMPANY_CODE SELLING_COMPANY_CODE INVOICE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
PREFIX	VARCHAR2	(3)		Prefix
BUYING_COMPANY_CODE	VARCHAR2	(10)	Yes	Buying Company Code
SELLING_COMPANY_CODE	VARCHAR2	(10)	Yes	Selling Company Code
INVOICE_TYPE	VARCHAR2	(3)	Yes	Invoice Type
NEXT_SEQUENCE_NUMBER	NUMBER	(15)	Yes	Next Sequence Number

Query Text

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


SELECT PREFIX
,      BUYING_COMPANY_CODE
,      SELLING_COMPANY_CODE
,      INVOICE_TYPE
,      NEXT_SEQUENCE_NUMBER
FROM PO.RCV_GAPLESS_INVOICE_NUMBERS;

Dependencies

[top of page]

PO.RCV_GAPLESS_INVOICE_NUMBERS does not reference any database object

PO.RCV_GAPLESS_INVOICE_NUMBERS is referenced by following:

PO: RCV_GAPLESS_INVOICE_NUMBERS#