[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 |