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

TABLE: JA.JAI_FA_MASS_ADDITIONS

Object Details
Object Name: JAI_FA_MASS_ADDITIONS
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_FA_MASS_ADDITIONS
Subobject Name:
Status: VALID


Stores the payable invoice details for those assets, which have been added as a part of bulk import.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_FA_MASS_ADDITIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMASS_ADDITION_ID
Columns
Name Datatype Length Mandatory Comments
MASS_ADDITION_ID NUMBER (15) Yes Mass addition Identifier
INVOICE_ID NUMBER (15)
Invoice Identifier
DISTRIBUTION_LINE_NUMBER NUMBER (15)
Distribution Line Number
PROCESS_FLAG VARCHAR2 (1)
Process Flag Indicator
PROCESS_MESSAGE VARCHAR2 (150)
Stores the error messages generated during bulk processing
BOOK_TYPE_CODE VARCHAR2 (15)
Asset Book Name
DATE_PLACED_IN_SERVICE DATE

Date when the Asset was placed in service.
CREATE_BATCH_DATE DATE

System date of the mass additions create program
INVOICE_NUMBER VARCHAR2 (50)
Invoice Number
INVOICE_DATE DATE

Invoice Date
VENDOR_NUMBER VARCHAR2 (30)
Supplier number
PO_NUMBER VARCHAR2 (20)
Purchase Order Number
ASSET_TYPE VARCHAR2 (11)
Indicates type of asset
ACCOUNTING_DATE DATE

Date on which the accounting was done for the asset.
PAYABLES_CODE_COMBINATION_ID NUMBER (15)
Code combination identifier
CREATED_BY NUMBER (15)
Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATE_BATCH_ID NUMBER (15)
Batch creation identifier
DEPRECIATE_STATUS VARCHAR2 (3)
Depreciate flag
OBJECT_VERSION_NUMBER NUMBER

Object version number
INVOICE_LINE_NUMBER NUMBER (15)
Invoice line number
Query Text

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


SELECT MASS_ADDITION_ID
,      INVOICE_ID
,      DISTRIBUTION_LINE_NUMBER
,      PROCESS_FLAG
,      PROCESS_MESSAGE
,      BOOK_TYPE_CODE
,      DATE_PLACED_IN_SERVICE
,      CREATE_BATCH_DATE
,      INVOICE_NUMBER
,      INVOICE_DATE
,      VENDOR_NUMBER
,      PO_NUMBER
,      ASSET_TYPE
,      ACCOUNTING_DATE
,      PAYABLES_CODE_COMBINATION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATE_BATCH_ID
,      DEPRECIATE_STATUS
,      OBJECT_VERSION_NUMBER
,      INVOICE_LINE_NUMBER
FROM JA.JAI_FA_MASS_ADDITIONS;

Dependencies

[top of page]

JA.JAI_FA_MASS_ADDITIONS does not reference any database object

JA.JAI_FA_MASS_ADDITIONS is referenced by following:

SchemaJA
ViewJAI_FA_MASS_ADDITIONS#