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

TABLE: PA.PA_RP_JOB_ASSIGNMENTS_HISTORY

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


This table stores the information regarding history of job assignments.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_RP_JOB_ASSIGNMENTS_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAIN_REQUEST_ID
ColumnWORKER_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ID NUMBER (15) Yes Assignment Id
MAIN_REQUEST_ID NUMBER (15) Yes Main Request Id
WORKER_REQUEST_ID NUMBER (15)
Worker Request Id
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_HISTORY;

Dependencies

[top of page]

PA.PA_RP_JOB_ASSIGNMENTS_HISTORY does not reference any database object

PA.PA_RP_JOB_ASSIGNMENTS_HISTORY is referenced by following:

SchemaAPPS
SynonymPA_RP_JOB_ASSIGNMENTS_HISTORY