View: FAFV_SRC_LNS

Product:	OFA - Assets
Description:	- Retrofitted
Implementation/DBA Data:	APPS.FAFV_SRC_LNS

View Text

SELECT AI.FIXED_ASSETS_COST
, AI.PAYABLES_COST
, AI.DESCRIPTION
, AI.ASSET_ID
, AD.ASSET_NUMBER
, AI.PO_VENDOR_ID
, VE.VENDOR_NAME
, AI.PO_NUMBER
, AI.INVOICE_NUMBER
, AI.INVOICE_DATE
, AI.INVOICE_ID
, AI.AP_DISTRIBUTION_LINE_NUMBER
, AI.PROJECT_ID
, PR.NAME
, AI.TASK_ID
, TA.TASK_NAME
, AI.LAST_UPDATE_DATE
, AI.LAST_UPDATED_BY
, AI.CREATED_BY
, AI.CREATION_DATE
, AI.INVOICE_LINE_NUMBER
, AI.INVOICE_DISTRIBUTION_ID
FROM FA_ASSET_INVOICES AI
, FA_ADDITIONS AD
, PO_VENDORS VE
, PA_PROJECTS PR
, PA_TASKS TA
WHERE AI.INVOICE_TRANSACTION_ID_OUT IS NULL
AND AI.DATE_INEFFECTIVE IS NULL
AND AI.ASSET_ID = AD.ASSET_ID
AND AI.PO_VENDOR_ID = VE.VENDOR_ID(+)
AND AI.PROJECT_ID = PR.PROJECT_ID (+)
AND AI.TASK_ID = TA.TASK_ID (+) WITH READ ONLY

Columns