[Home] [Help] [Dependency Information]
Object Name: | PA_ROUTINGS |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_ROUTINGS |
Subobject Name: | |
Status: | VALID |
PA_ROUTINGS stores the sequential steps in the
approval cycles of online timecards and expense
reports from Oracle Personal Time and Expense.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_ROUTINGS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
EXPENDITURE_ID
START_DATE |
PA_ROUTINGS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
ROUTING_STATUS_CODE
ROUTED_TO_PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXPENDITURE_ID | NUMBER | (15) | Yes | The identifier of the expenditure for which this routing is entered |
ROUTED_FROM_PERSON_ID | NUMBER | (9) | Yes | The identifier of the person who sent this routing |
START_DATE | DATE | Yes | The date that the approval step was performed. This values include date and time | |
ROUTING_STATUS_CODE | VARCHAR2 | (30) | Yes | The approval action performed for this routing |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
ROUTED_TO_PERSON_ID | NUMBER | (9) | The identifier of the person to which the expenditure is sent for the next approval step. This column is left blank if the approval step is approval of the expenditure | |
END_DATE | DATE | The date on which the next approval step was performed. This value includes date and time. This column is left blank if the approval step is approval of the expenditure | ||
ROUTING_COMMENT | VARCHAR2 | (240) | The free text comment written by the person from whom the routing was sent |
Cut, paste (and edit) the following text to query this object:
SELECT EXPENDITURE_ID
, ROUTED_FROM_PERSON_ID
, START_DATE
, ROUTING_STATUS_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ROUTED_TO_PERSON_ID
, END_DATE
, ROUTING_COMMENT
FROM PA.PA_ROUTINGS;
PA.PA_ROUTINGS does not reference any database object
PA.PA_ROUTINGS is referenced by following:
|
|
|