VIEW: APPS.FAFV_SRC_LNS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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