[Home] [Help]
View: FABV_SRC_LNS
| Product: | OFA - Assets |
| Description: | - Retrofitted |
| Implementation/DBA Data: |
APPS.FABV_SRC_LNS
|
View Text
SELECT FIXED_ASSETS_COST
, PAYABLES_COST
, DESCRIPTION
, ASSET_ID
, PO_VENDOR_ID
, PO_NUMBER
, INVOICE_NUMBER
, INVOICE_DATE
, INVOICE_ID
, AP_DISTRIBUTION_LINE_NUMBER
, PROJECT_ID
, TASK_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, INVOICE_LINE_NUMBER
, INVOICE_DISTRIBUTION_ID
FROM FA_ASSET_INVOICES
WHERE INVOICE_TRANSACTION_ID_OUT IS NULL
AND DATE_INEFFECTIVE IS NULL WITH READ ONLY
Columns
| Name |
| FIXED_ASSETS_COST |
| PAYABLES_COST |
| DESCRIPTION |
| ASSET_ID |
| PO_VENDOR_ID |
| PO_NUMBER |
| INVOICE_NUMBER |
| INVOICE_DATE |
| INVOICE_ID |
| AP_DISTRIBUTION_LINE_NUMBER |
| PROJECT_ID |
| TASK_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |
| INVOICE_LINE_NUMBER |
| INVOICE_DISTRIBUTION_ID |