DBA Data[Home] [Help] [Dependency Information]

TABLE: ONT.OE_INVOICE_NUMBERS

Object Details
Object Name: OE_INVOICE_NUMBERS
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_INVOICE_NUMBERS
Subobject Name:
Status: VALID


This table is used for generating invoice numbers based on the delivery name.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_INVOICE_NUMBERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_NUMBER_ID NUMBER
Yes Unique id generated
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent request that last changed row
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated row.
PROGRAM_ID NUMBER

Concurrent program that last updated row.
PROGRAM_UPDATE_DATE DATE

Last date changed by concurrent program
DELIVERY_ID NUMBER
Yes To keep track of delivery ids while generating invoice numbers based on delivery name
INDEX_NUMBER NUMBER
Yes To keep track of max index used for a delivery while generating invoice numbers based on delivery name
Query Text

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


SELECT INVOICE_NUMBER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DELIVERY_ID
,      INDEX_NUMBER
FROM ONT.OE_INVOICE_NUMBERS;

Dependencies

[top of page]

ONT.OE_INVOICE_NUMBERS does not reference any database object

ONT.OE_INVOICE_NUMBERS is referenced by following:

SchemaONT
ViewOE_INVOICE_NUMBERS#