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]

VIEW: FA.FA_PARALLEL_WORKERS#

Object Details

Object Name:	FA_PARALLEL_WORKERS#
Object Type:	VIEW
Owner:	FA
Subobject Name:
Status:	VALID

[View Source]

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# references the following:

FA: FA_PARALLEL_WORKERS

FA.FA_PARALLEL_WORKERS# is referenced by following:

APPS: FA_PARALLEL_WORKERS