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


TABLE: PA.PA_WF_PROCESS_DETAILS_AR

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


PA_WF_PROCESS_DETAILS_AR is a table for Archive/Purge.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_WF_PROCESS_DETAILS_AR_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPURGE_PROJECT_ID
Columns
Name Datatype Length Mandatory Comments
PURGE_BATCH_ID NUMBER (15) Yes Purge batch id
PURGE_PROJECT_ID NUMBER (15) Yes Purged Project id
PURGE_RELEASE VARCHAR2 (50) Yes Purge release version
WF_TYPE_CODE VARCHAR2 (30)
This code indicates the workflow type
ITEM_TYPE VARCHAR2 (30)
This is the workflow item type
ITEM_KEY VARCHAR2 (240)
This is the workflow item key
OBJECT_ID1 NUMBER

This is the primary key of the entity whose items are being processed by the workflow process
OBJECT_ID2 NUMBER

This is a supplemental column for storing the primary key of the entity whose items are being processed by the workflow process
PROCESS_STATUS_CODE VARCHAR2 (30)
This is the status of the process
SOURCE_ATTRIBUTE1 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE2 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE3 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE4 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE5 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE6 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE7 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE8 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE9 VARCHAR2 (150)
This stores an attribute of the workflow process
SOURCE_ATTRIBUTE10 VARCHAR2 (150)
This stores an attribute of the workflow process
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PURGE_BATCH_ID
,      PURGE_PROJECT_ID
,      PURGE_RELEASE
,      WF_TYPE_CODE
,      ITEM_TYPE
,      ITEM_KEY
,      OBJECT_ID1
,      OBJECT_ID2
,      PROCESS_STATUS_CODE
,      SOURCE_ATTRIBUTE1
,      SOURCE_ATTRIBUTE2
,      SOURCE_ATTRIBUTE3
,      SOURCE_ATTRIBUTE4
,      SOURCE_ATTRIBUTE5
,      SOURCE_ATTRIBUTE6
,      SOURCE_ATTRIBUTE7
,      SOURCE_ATTRIBUTE8
,      SOURCE_ATTRIBUTE9
,      SOURCE_ATTRIBUTE10
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_WF_PROCESS_DETAILS_AR;

Dependencies

[top of page]

PA.PA_WF_PROCESS_DETAILS_AR does not reference any database object

PA.PA_WF_PROCESS_DETAILS_AR is referenced by following:

SchemaAPPS
SynonymPA_WF_PROCESS_DETAILS_AR