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

TABLE: PA.PA_INV_GRP_COL_WHR_CLAUSES

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


PA_INV_GRP_COL_WHR_CLAUSES links table columns to the SQL
statement WHERE clauses that invoice groups use to
derive column values.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 2
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_INV_GRP_COL_WHR_CLAUSES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnINVOICE_GROUP_COLUMN_ID
ColumnINVOICE_GROUP_WHERE_CLAUSE_ID
PA_INV_GRP_COL_WHR_CLAUSES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnINVOICE_GROUP_WHERE_CLAUSE_ID
Columns
Name Datatype Length Mandatory Comments
INVOICE_GROUP_COLUMN_ID NUMBER (15) Yes The identifier of the invoice group column that is assigned to the column where clauses
INVOICE_GROUP_WHERE_CLAUSE_ID NUMBER (15) Yes The identifier of the invoice group column where clause that is assigned to the invoice group column
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
Query Text

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


SELECT INVOICE_GROUP_COLUMN_ID
,      INVOICE_GROUP_WHERE_CLAUSE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_INV_GRP_COL_WHR_CLAUSES;

Dependencies

[top of page]

PA.PA_INV_GRP_COL_WHR_CLAUSES does not reference any database object

PA.PA_INV_GRP_COL_WHR_CLAUSES is referenced by following:

SchemaAPPS
SynonymPA_INV_GRP_COL_WHR_CLAUSES