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_DELETED_MASS_ADDITIONS#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
INVOICE_ID	NUMBER	(15)
AP_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)
CREATE_BATCH_ID	NUMBER	(15)
POST_BATCH_ID	NUMBER	(15)
STATUS	VARCHAR2	(1)
PAYABLES_CODE_COMBINATION_ID	NUMBER	(15)
FEEDER_SYSTEM_NAME	VARCHAR2	(40)
CREATE_BATCH_DATE	DATE
INVOICE_DATE	DATE
PAYABLES_COST	NUMBER
PAYABLES_UNITS	NUMBER
REVIEWER_COMMENTS	VARCHAR2	(60)
BOOK_TYPE_CODE	VARCHAR2	(15)
DESCRIPTION	VARCHAR2	(80)
MASS_ADDITION_ID	NUMBER	(15)	Yes
PROJECT_ASSET_LINE_ID	NUMBER	(15)
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
INVOICE_DISTRIBUTION_ID	NUMBER	(15)
INVOICE_LINE_NUMBER	NUMBER

Query Text

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


SELECT INVOICE_ID
,      AP_DISTRIBUTION_LINE_NUMBER
,      CREATE_BATCH_ID
,      POST_BATCH_ID
,      STATUS
,      PAYABLES_CODE_COMBINATION_ID
,      FEEDER_SYSTEM_NAME
,      CREATE_BATCH_DATE
,      INVOICE_DATE
,      PAYABLES_COST
,      PAYABLES_UNITS
,      REVIEWER_COMMENTS
,      BOOK_TYPE_CODE
,      DESCRIPTION
,      MASS_ADDITION_ID
,      PROJECT_ASSET_LINE_ID
,      PROJECT_ID
,      TASK_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_LINE_NUMBER
FROM FA.FA_DELETED_MASS_ADDITIONS#;

Dependencies

[top of page]

FA.FA_DELETED_MASS_ADDITIONS# references the following:

FA: FA_DELETED_MASS_ADDITIONS

FA.FA_DELETED_MASS_ADDITIONS# is referenced by following:

APPS: FA_DELETED_MASS_ADDITIONS