[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FA_INVOICE_DETAILS_WEB_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OFA.FA_INVOICE_DETAILS_WEB_V
|
| Subobject Name: | |
| Status: | VALID |
A Web view designed to simplify access from Oracle Self-Service Web Applications.
This web inquiry view contains detailed invoice information pertaining
to a particular asset.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Refer to base table | |
| ASSET_ID | NUMBER | (15) | Yes | Refer to base table |
| PO_VENDOR_ID | NUMBER | (15) | Refer to base table | |
| ASSET_INVOICE_ID | NUMBER | (15) | Refer to base table | |
| FIXED_ASSETS_COST | VARCHAR2 | (4000) | Refer to base table | |
| DATE_EFFECTIVE | DATE | Yes | Refer to base table | |
| DATE_INEFFECTIVE | DATE | Refer to base table | ||
| INVOICE_TRANSACTION_ID_IN | NUMBER | (15) | Refer to base table | |
| INVOICE_TRANSACTION_ID_OUT | NUMBER | (15) | Refer to base table | |
| DELETED_FLAG | VARCHAR2 | (80) | Refer to base table | |
| PO_NUMBER | VARCHAR2 | (20) | Refer to base table | |
| INVOICE_NUMBER | VARCHAR2 | (50) | Refer to base table | |
| PAYABLES_BATCH_NAME | VARCHAR2 | (50) | Refer to base table | |
| PAYABLES_CODE_COMBINATION_ID | NUMBER | (15) | Refer to base table | |
| FEEDER_SYSTEM_NAME | VARCHAR2 | (40) | Refer to base table | |
| CREATE_BATCH_DATE | DATE | Refer to base table | ||
| CREATE_BATCH_ID | NUMBER | (15) | Refer to base table | |
| INVOICE_DATE | DATE | Refer to base table | ||
| PAYABLES_COST | VARCHAR2 | (4000) | Refer to base table | |
| POST_BATCH_ID | NUMBER | (15) | Refer to base table | |
| INVOICE_ID | NUMBER | (15) | Refer to base table | |
| AP_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Refer to base table | |
| PAYABLES_UNITS | NUMBER | Refer to base table | ||
| SPLIT_MERGED_CODE | VARCHAR2 | (3) | Refer to base table | |
| DESCRIPTION | VARCHAR2 | (80) | Refer to base table | |
| PARENT_MASS_ADDITION_ID | VARCHAR2 | (15) | Refer to base table | |
| LAST_UPDATE_DATE | DATE | Yes | Refer to base table | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Refer to base table |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Refer to base table | |
| CREATED_BY | NUMBER | (15) | Refer to base table | |
| CREATION_DATE | DATE | Refer to base table | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Refer to base table | |
| ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Refer to base table | |
| UNREVALUED_COST | VARCHAR2 | (4000) | Refer to base table | |
| MERGED_CODE | VARCHAR2 | (3) | Refer to base table | |
| SPLIT_CODE | VARCHAR2 | (3) | Refer to base table | |
| MERGE_PARENT_MASS_ADDITIONS_ID | NUMBER | (15) | Refer to base table | |
| SPLIT_PARENT_MASS_ADDITIONS_ID | NUMBER | (15) | Refer to base table | |
| PROJECT_ASSET_LINE_ID | NUMBER | (15) | Refer to base table | |
| PROJECT_ID | NUMBER | (15) | Refer to base table | |
| TASK_ID | NUMBER | (15) | Refer to base table | |
| VENDOR_NUMBER | VARCHAR2 | (30) | Refer to base table | |
| VENDOR_NAME | VARCHAR2 | (240) | Refer to base table | |
| INVOICE_LINE_NUMBER | NUMBER | Refer to base table |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, 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
, VENDOR_NUMBER
, VENDOR_NAME
, INVOICE_LINE_NUMBER
FROM APPS.FA_INVOICE_DETAILS_WEB_V;
APPS
FA_ASSET_INVOICES
FA_LOOKUPS
FND_CURRENCY
- show dependent code
PO_VENDORS
APPS.FA_INVOICE_DETAILS_WEB_V is not referenced by any database object
|
|
|
|