eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FA.FA_PARALLEL_WORKERS

Object Details

Object Name:	FA_PARALLEL_WORKERS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_PARALLEL_WORKERS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_PARALLEL_WORKERS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REQUEST_ID WORKER_NUMBER PROCESS_STATUS PROCESS_ORDER
FA_PARALLEL_WORKERS_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REQUEST_ID TRANSACTION_TYPE_CODE PARENT_ASSET_ID
FA_PARALLEL_WORKERS_N3	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	REQUEST_ID ASSET_ID TRANSACTION_TYPE_CODE

Columns

Name	Datatype	Length
PROGRAM	VARCHAR2	(15)
WORKER_NUMBER	NUMBER
START_TIME	DATE
CONC_REQ_NUM	NUMBER
ASSET_ID	NUMBER	(15)
ASSET_NUMBER	VARCHAR2	(15)
ASSET_TYPE	VARCHAR2	(11)
ASSET_CATEGORY_ID	NUMBER	(15)
PARENT_ASSET_ID	NUMBER	(15)
BOOK_TYPE_CODE	VARCHAR2	(15)
TRANSACTION_DATE_ENTERED	DATE
CORP_TRANSACTION_HEADER_ID	NUMBER	(15)
TAX_TRANSACTION_HEADER_ID	NUMBER	(15)
TRANSACTION_TYPE_CODE	VARCHAR2	(20)
OLD_GROUP_ASSET_ID	NUMBER	(15)
NEW_GROUP_ASSET_ID	NUMBER	(15)
PROCESS_ORDER	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
PROCESS_STATUS	VARCHAR2	(15)

Query Text

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


SELECT PROGRAM
,      WORKER_NUMBER
,      START_TIME
,      CONC_REQ_NUM
,      ASSET_ID
,      ASSET_NUMBER
,      ASSET_TYPE
,      ASSET_CATEGORY_ID
,      PARENT_ASSET_ID
,      BOOK_TYPE_CODE
,      TRANSACTION_DATE_ENTERED
,      CORP_TRANSACTION_HEADER_ID
,      TAX_TRANSACTION_HEADER_ID
,      TRANSACTION_TYPE_CODE
,      OLD_GROUP_ASSET_ID
,      NEW_GROUP_ASSET_ID
,      PROCESS_ORDER
,      REQUEST_ID
,      PROCESS_STATUS
FROM FA.FA_PARALLEL_WORKERS;

Dependencies

[top of page]

FA.FA_PARALLEL_WORKERS does not reference any database object

FA.FA_PARALLEL_WORKERS is referenced by following:

APPS: FA_PARALLEL_WORKERS