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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

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 PARENT_ASSET_ID

Columns

Name	Datatype	Length	Comments
PROGRAM	VARCHAR2	(15)	Program name.
WORKER_NUMBER	NUMBER		Concurrent (parallel) worker number.
START_TIME	DATE		Date/time worker started.
CONC_REQ_NUM	NUMBER		Concurrent request that this worker is running.
ASSET_ID	NUMBER	(15)	Internal asset identifier
ASSET_NUMBER	VARCHAR2	(15)	Asset number
ASSET_TYPE	VARCHAR2	(11)	Indicates whether the asset is CIP, capitalized, or expensed
ASSET_CATEGORY_ID	NUMBER	(15)	Identifies the category to which the asset belongs
PARENT_ASSET_ID	NUMBER	(15)	Internal asset identifier of the parent asset
BOOK_TYPE_CODE	VARCHAR2	(15)	Asset book
TRANSACTION_DATE_ENTERED	DATE		Date on which the transaction occurred
CORP_TRANSACTION_HEADER_ID	NUMBER	(15)	Internal corporate transaction identifier
TAX_TRANSACTION_HEADER_ID	NUMBER	(15)	Internal tax transaction identifier
TRANSACTION_TYPE_CODE	VARCHAR2	(20)	Identifies the type of transaction
OLD_GROUP_ASSET_ID	NUMBER	(15)	Old group asset identifier
NEW_GROUP_ASSET_ID	NUMBER	(15)	New group asset identifier
PROCESS_ORDER	NUMBER	(15)	Internal identifier indicating the order in which transactions should be processed
REQUEST_ID	NUMBER	(15)	Internal identifier for the parent request ID of the posting program.
PROCESS_STATUS	VARCHAR2	(15)	Internal status of the transaction

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:

FA: FA_PARALLEL_WORKERS#