[Home] [Help] [Dependency Information]
Object Name: | FA_ASSET_INVOICES_MRC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OFA.FA_ASSET_INVOICES_MRC_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
EXCHANGE_RATE | NUMBER | |||
ASSET_ID | NUMBER | (15) | Yes | |
PO_VENDOR_ID | NUMBER | (15) | ||
ASSET_INVOICE_ID | NUMBER | (15) | ||
FIXED_ASSETS_COST | NUMBER | |||
DATE_EFFECTIVE | DATE | Yes | ||
DATE_INEFFECTIVE | DATE | |||
INVOICE_TRANSACTION_ID_IN | NUMBER | (15) | ||
INVOICE_TRANSACTION_ID_OUT | NUMBER | (15) | ||
DELETED_FLAG | VARCHAR2 | (3) | Yes | |
PO_NUMBER | VARCHAR2 | (20) | ||
INVOICE_NUMBER | VARCHAR2 | (50) | ||
PAYABLES_BATCH_NAME | VARCHAR2 | (50) | ||
PAYABLES_CODE_COMBINATION_ID | NUMBER | (15) | ||
FEEDER_SYSTEM_NAME | VARCHAR2 | (40) | ||
CREATE_BATCH_DATE | DATE | |||
CREATE_BATCH_ID | NUMBER | (15) | ||
INVOICE_DATE | DATE | |||
PAYABLES_COST | NUMBER | |||
POST_BATCH_ID | NUMBER | (15) | ||
INVOICE_ID | NUMBER | (15) | ||
AP_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
PAYABLES_UNITS | NUMBER | |||
SPLIT_MERGED_CODE | VARCHAR2 | (3) | ||
DESCRIPTION | VARCHAR2 | (80) | ||
PARENT_MASS_ADDITION_ID | VARCHAR2 | (15) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | ||
UNREVALUED_COST | NUMBER | |||
MERGED_CODE | VARCHAR2 | (3) | ||
SPLIT_CODE | VARCHAR2 | (3) | ||
MERGE_PARENT_MASS_ADDITIONS_ID | NUMBER | (15) | ||
SPLIT_PARENT_MASS_ADDITIONS_ID | NUMBER | (15) | ||
PROJECT_ASSET_LINE_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
SOURCE_LINE_ID | NUMBER | (15) | Yes | |
DEPRECIATE_IN_GROUP_FLAG | VARCHAR2 | (1) | Indicates whether the source line will be included in the depreciable basis of any associated group asset. | |
MATERIAL_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates whether the source line is material or non-material in nature | |
PRIOR_SOURCE_LINE_ID | NUMBER | (15) | Source line identifier corresponding to the row terminated by the invoice transaction which created this row | |
INVOICE_LINE_NUMBER | NUMBER | Invoice line number | ||
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Invoice distribution identifier | |
PO_DISTRIBUTION_ID | NUMBER | (15) | Purchase order distribution identifier |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, EXCHANGE_RATE
, ASSET_ID
, PO_VENDOR_ID
, ASSET_INVOICE_ID
, FIXED_ASSETS_COST
, DATE_EFFECTIVE
, DATE_INEFFECTIVE
, INVOICE_TRANSACTION_ID_IN
, INVOICE_TRANSACTION_ID_OUT
, DELETED_FLAG
, PO_NUMBER
, INVOICE_NUMBER
, PAYABLES_BATCH_NAME
, PAYABLES_CODE_COMBINATION_ID
, FEEDER_SYSTEM_NAME
, CREATE_BATCH_DATE
, CREATE_BATCH_ID
, INVOICE_DATE
, PAYABLES_COST
, POST_BATCH_ID
, INVOICE_ID
, AP_DISTRIBUTION_LINE_NUMBER
, PAYABLES_UNITS
, SPLIT_MERGED_CODE
, DESCRIPTION
, PARENT_MASS_ADDITION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
, UNREVALUED_COST
, MERGED_CODE
, SPLIT_CODE
, MERGE_PARENT_MASS_ADDITIONS_ID
, SPLIT_PARENT_MASS_ADDITIONS_ID
, PROJECT_ASSET_LINE_ID
, PROJECT_ID
, TASK_ID
, SOURCE_LINE_ID
, DEPRECIATE_IN_GROUP_FLAG
, MATERIAL_INDICATOR_FLAG
, PRIOR_SOURCE_LINE_ID
, INVOICE_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID
, PO_DISTRIBUTION_ID
FROM APPS.FA_ASSET_INVOICES_MRC_V;
APPS.FA_ASSET_INVOICES_MRC_V is not referenced by any database object
|
|
|