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

TABLE: FA.FA_DELETED_MASS_ADDITIONS

Object Details
Object Name: FA_DELETED_MASS_ADDITIONS
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_DELETED_MASS_ADDITIONS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FA_DELETED_MASS_ADDITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnMASS_ADDITION_ID
Columns
Name Datatype Length Mandatory Comments
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 does not reference any database object

FA.FA_DELETED_MASS_ADDITIONS is referenced by following:

SchemaAPPS
SynonymFA_DELETED_MASS_ADDITIONS