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

TABLE: PA.PA_RP_JOB_ASSIGNMENTS

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


This table stores the information regarding job assignments.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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
Query Text

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;

Dependencies

[top of page]

PA.PA_RP_JOB_ASSIGNMENTS does not reference any database object

PA.PA_RP_JOB_ASSIGNMENTS is referenced by following:

SchemaAPPS
SynonymPA_RP_JOB_ASSIGNMENTS