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

TABLE: PA.PA_INVOICE_GROUP_TABLES

Object Details
Object Name: PA_INVOICE_GROUP_TABLES
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_INVOICE_GROUP_TABLES
Subobject Name:
Status: VALID


PA_INVOICE_GROUP_TABLES stores the names of the tables used
by an invoice group to derive column values. Oracle Projects
provides all invoices group tables upon
installation.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 2
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_INVOICE_GROUP_TABLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnINVOICE_GROUP_COLUMN_ID
ColumnINVOICE_GROUP_TABLE_NAME
Columns
Name Datatype Length Mandatory Comments
INVOICE_GROUP_COLUMN_ID NUMBER (15) Yes The identifier of the invoice group column whose value is determined using the invoice group table
INVOICE_GROUP_TABLE_NAME VARCHAR2 (30) Yes The name of the table
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
TEXT VARCHAR2 (240) Yes The text used in the from clause of the sql statement generated by the Generate Draft Invoices invoice formatting routine
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT INVOICE_GROUP_COLUMN_ID
,      INVOICE_GROUP_TABLE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      TEXT
,      ZD_EDITION_NAME
FROM PA.PA_INVOICE_GROUP_TABLES;

Dependencies

[top of page]

PA.PA_INVOICE_GROUP_TABLES does not reference any database object

PA.PA_INVOICE_GROUP_TABLES is referenced by following:

SchemaPA
ViewPA_INVOICE_GROUP_TABLES#