FND Design Data [Home] [Help]

View: FABV_SRC_LNS

Product: OFA - Assets
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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