VIEW: APPS.FA_INVOICE_DETAILS_WEB_V

Source

View Text - Preformatted

SELECT AI.ROWID ROW_ID , AI.ASSET_ID , AI.PO_VENDOR_ID , AI.ASSET_INVOICE_ID , TO_CHAR(AI.FIXED_ASSETS_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(PO.INVOICE_CURRENCY_CODE,30)) FIXED_ASSETS_COST , AI.DATE_EFFECTIVE , AI.DATE_INEFFECTIVE , AI.INVOICE_TRANSACTION_ID_IN , AI.INVOICE_TRANSACTION_ID_OUT , LU.MEANING DELETED_FLAG , AI.PO_NUMBER , AI.INVOICE_NUMBER , AI.PAYABLES_BATCH_NAME , AI.PAYABLES_CODE_COMBINATION_ID , AI.FEEDER_SYSTEM_NAME , AI.CREATE_BATCH_DATE , AI.CREATE_BATCH_ID , AI.INVOICE_DATE , TO_CHAR(AI.PAYABLES_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(PO.INVOICE_CURRENCY_CODE,30)) PAYABLES_COST , AI.POST_BATCH_ID , AI.INVOICE_ID , AI.AP_DISTRIBUTION_LINE_NUMBER , AI.PAYABLES_UNITS , AI.SPLIT_MERGED_CODE , AI.DESCRIPTION , AI.PARENT_MASS_ADDITION_ID , AI.LAST_UPDATE_DATE , AI.LAST_UPDATED_BY , AI.LAST_UPDATE_LOGIN , AI.CREATED_BY , AI.CREATION_DATE , AI.ATTRIBUTE1 , AI.ATTRIBUTE2 , AI.ATTRIBUTE3 , AI.ATTRIBUTE4 , AI.ATTRIBUTE5 , AI.ATTRIBUTE6 , AI.ATTRIBUTE7 , AI.ATTRIBUTE8 , AI.ATTRIBUTE9 , AI.ATTRIBUTE10 , AI.ATTRIBUTE11 , AI.ATTRIBUTE12 , AI.ATTRIBUTE13 , AI.ATTRIBUTE14 , AI.ATTRIBUTE15 , AI.ATTRIBUTE_CATEGORY_CODE , TO_CHAR(AI.UNREVALUED_COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(PO.INVOICE_CURRENCY_CODE,30)) UNREVALUED_COST , AI.MERGED_CODE , AI.SPLIT_CODE , AI.MERGE_PARENT_MASS_ADDITIONS_ID , AI.SPLIT_PARENT_MASS_ADDITIONS_ID , AI.PROJECT_ASSET_LINE_ID , AI.PROJECT_ID , AI.TASK_ID , PO.SEGMENT1 VENDOR_NUMBER , PO.VENDOR_NAME , AI.INVOICE_LINE_NUMBER FROM PO_VENDORS PO, FA_LOOKUPS LU, FA_ASSET_INVOICES AI WHERE AI.DATE_INEFFECTIVE IS NULL AND DECODE(AI.DELETED_FLAG,'YES','NO', 'NO', 'YES') = LU.LOOKUP_CODE AND LU.LOOKUP_TYPE = 'YESNO' AND PO.VENDOR_ID(+) = AI.PO_VENDOR_ID

View Text - HTML Formatted

SELECT AI.ROWID ROW_ID
, AI.ASSET_ID
, AI.PO_VENDOR_ID
, AI.ASSET_INVOICE_ID
, TO_CHAR(AI.FIXED_ASSETS_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(PO.INVOICE_CURRENCY_CODE
, 30)) FIXED_ASSETS_COST
, AI.DATE_EFFECTIVE
, AI.DATE_INEFFECTIVE
, AI.INVOICE_TRANSACTION_ID_IN
, AI.INVOICE_TRANSACTION_ID_OUT
, LU.MEANING DELETED_FLAG
, AI.PO_NUMBER
, AI.INVOICE_NUMBER
, AI.PAYABLES_BATCH_NAME
, AI.PAYABLES_CODE_COMBINATION_ID
, AI.FEEDER_SYSTEM_NAME
, AI.CREATE_BATCH_DATE
, AI.CREATE_BATCH_ID
, AI.INVOICE_DATE
, TO_CHAR(AI.PAYABLES_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(PO.INVOICE_CURRENCY_CODE
, 30)) PAYABLES_COST
, AI.POST_BATCH_ID
, AI.INVOICE_ID
, AI.AP_DISTRIBUTION_LINE_NUMBER
, AI.PAYABLES_UNITS
, AI.SPLIT_MERGED_CODE
, AI.DESCRIPTION
, AI.PARENT_MASS_ADDITION_ID
, AI.LAST_UPDATE_DATE
, AI.LAST_UPDATED_BY
, AI.LAST_UPDATE_LOGIN
, AI.CREATED_BY
, AI.CREATION_DATE
, AI.ATTRIBUTE1
, AI.ATTRIBUTE2
, AI.ATTRIBUTE3
, AI.ATTRIBUTE4
, AI.ATTRIBUTE5
, AI.ATTRIBUTE6
, AI.ATTRIBUTE7
, AI.ATTRIBUTE8
, AI.ATTRIBUTE9
, AI.ATTRIBUTE10
, AI.ATTRIBUTE11
, AI.ATTRIBUTE12
, AI.ATTRIBUTE13
, AI.ATTRIBUTE14
, AI.ATTRIBUTE15
, AI.ATTRIBUTE_CATEGORY_CODE
, TO_CHAR(AI.UNREVALUED_COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(PO.INVOICE_CURRENCY_CODE
, 30)) UNREVALUED_COST
, AI.MERGED_CODE
, AI.SPLIT_CODE
, AI.MERGE_PARENT_MASS_ADDITIONS_ID
, AI.SPLIT_PARENT_MASS_ADDITIONS_ID
, AI.PROJECT_ASSET_LINE_ID
, AI.PROJECT_ID
, AI.TASK_ID
, PO.SEGMENT1 VENDOR_NUMBER
, PO.VENDOR_NAME
, AI.INVOICE_LINE_NUMBER
FROM PO_VENDORS PO
, FA_LOOKUPS LU
, FA_ASSET_INVOICES AI
WHERE AI.DATE_INEFFECTIVE IS NULL
AND DECODE(AI.DELETED_FLAG
, 'YES'
, 'NO'
, 'NO'
, 'YES') = LU.LOOKUP_CODE
AND LU.LOOKUP_TYPE = 'YESNO'
AND PO.VENDOR_ID(+) = AI.PO_VENDOR_ID