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

TABLE: AP.AP_POL_ITEMIZATIONS

Object Details
Object Name: AP_POL_ITEMIZATIONS
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_POL_ITEMIZATIONS
Subobject Name:
Status: VALID


AP_POL_ITEMIZATIONS is a Policy Compliance-specific table that contains itemization information for expense types. The data in this table is used on the expense report to determine whether expense types require itemization. The primary key for this table is PARAMETER_ID and ITEMIZATION_PARAMETER_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_POL_ITEMIZATIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAMETER_ID
ColumnITEMIZATION_PARAMETER_ID
AP_POL_ITEMIZATIONS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEMIZATION_PARAMETER_ID
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER (15) Yes Parent expense item identifier.
ITEMIZATION_PARAMETER_ID NUMBER (15) Yes Child expense item identifier.
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT PARAMETER_ID
,      ITEMIZATION_PARAMETER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM AP.AP_POL_ITEMIZATIONS;

Dependencies

[top of page]

AP.AP_POL_ITEMIZATIONS does not reference any database object

AP.AP_POL_ITEMIZATIONS is referenced by following:

SchemaAPPS
SynonymAP_POL_ITEMIZATIONS