[Home] [Help] [Dependency Information]
Object Name: | PA_SPAWNED_PROGRAM_STATUSES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_SPAWNED_PROGRAM_STATUSES |
Subobject Name: | |
Status: | VALID |
PA_SPAWNED_PROGRAM_STATUSES stores statuses of spawned
programs. Currently the only spawned program in
Oracle Projects is the Overtime Calculation
program called from the Distribute Labor Costs
process. The Distribute Labor Costs process uses this
table to monitor the status of the Overtime
Calculation program.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_SPAWNED_PROGRAM_STATUSES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
REQUEST_ID
PROGRAM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | (15) | Yes | Standard Who Column |
PROGRAM_ID | NUMBER | (15) | Yes | Standard Who 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) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, PROGRAM_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
FROM PA.PA_SPAWNED_PROGRAM_STATUSES;
PA.PA_SPAWNED_PROGRAM_STATUSES does not reference any database object
PA.PA_SPAWNED_PROGRAM_STATUSES is referenced by following:
|
|
|