DBA Data[Home] [Help]

VIEW: APPS.FABV_SRC_LNS

Source

View Text - Preformatted

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
View Text - HTML Formatted

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