[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_RP_JOB_ASSIGNMENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_RP_JOB_ASSIGNMENTS
|
| Subobject Name: | |
| Status: | VALID |
This table stores the information regarding job assignments.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ASSIGNMENT_ID | NUMBER | (15) | Yes | Generated unique ID |
| MAIN_REQUEST_ID | NUMBER | (15) | Yes | The ID of the main concurrent request which populate the jobs |
| WORKER_REQUEST_ID | NUMBER | (15) | The ID of the worker concurrent request which process the job | |
| STATUS_FLAG | VARCHAR2 | (1) | Status of the job(C: created; P:processing; F: failed; null: success | |
| RP_ID | NUMBER | (15) | Yes | Reporting Pack ID |
| BURSTING_VALUE_1 | VARCHAR2 | (240) | Bursting Value 1 | |
| BURSTING_VALUE_2 | VARCHAR2 | (240) | Bursting Value 2 | |
| BURSTING_VALUE_3 | VARCHAR2 | (240) | Bursting Value 3 | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, MAIN_REQUEST_ID
, WORKER_REQUEST_ID
, STATUS_FLAG
, RP_ID
, BURSTING_VALUE_1
, BURSTING_VALUE_2
, BURSTING_VALUE_3
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM PA.PA_RP_JOB_ASSIGNMENTS;
PA.PA_RP_JOB_ASSIGNMENTS does not reference any database object
PA.PA_RP_JOB_ASSIGNMENTS is referenced by following:
APPS
PA_RP_JOB_ASSIGNMENTS
|
|
|
|