VIEW: FA.FA_ASSET_INVOICES#

Source

View Text - Preformatted

select ASSET_ID ASSET_ID, PO_VENDOR_ID PO_VENDOR_ID, ASSET_INVOICE_ID ASSET_INVOICE_ID, FIXED_ASSETS_COST FIXED_ASSETS_COST, DATE_EFFECTIVE DATE_EFFECTIVE, DATE_INEFFECTIVE DATE_INEFFECTIVE, INVOICE_TRANSACTION_ID_IN INVOICE_TRANSACTION_ID_IN, INVOICE_TRANSACTION_ID_OUT INVOICE_TRANSACTION_ID_OUT, DELETED_FLAG DELETED_FLAG, PO_NUMBER PO_NUMBER, INVOICE_NUMBER INVOICE_NUMBER, PAYABLES_BATCH_NAME PAYABLES_BATCH_NAME, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID, FEEDER_SYSTEM_NAME FEEDER_SYSTEM_NAME, CREATE_BATCH_DATE CREATE_BATCH_DATE, CREATE_BATCH_ID CREATE_BATCH_ID, INVOICE_DATE INVOICE_DATE, PAYABLES_COST PAYABLES_COST, POST_BATCH_ID POST_BATCH_ID, INVOICE_ID INVOICE_ID, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER, PAYABLES_UNITS PAYABLES_UNITS, SPLIT_MERGED_CODE SPLIT_MERGED_CODE, DESCRIPTION DESCRIPTION, PARENT_MASS_ADDITION_ID PARENT_MASS_ADDITION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE, UNREVALUED_COST UNREVALUED_COST, MERGED_CODE MERGED_CODE, SPLIT_CODE SPLIT_CODE, MERGE_PARENT_MASS_ADDITIONS_ID MERGE_PARENT_MASS_ADDITIONS_ID, SPLIT_PARENT_MASS_ADDITIONS_ID SPLIT_PARENT_MASS_ADDITIONS_ID, PROJECT_ASSET_LINE_ID PROJECT_ASSET_LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, SOURCE_LINE_ID SOURCE_LINE_ID, DEPRECIATE_IN_GROUP_FLAG DEPRECIATE_IN_GROUP_FLAG, MATERIAL_INDICATOR_FLAG MATERIAL_INDICATOR_FLAG, PRIOR_SOURCE_LINE_ID PRIOR_SOURCE_LINE_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID from "FA"."FA_ASSET_INVOICES"

View Text - HTML Formatted

SELECT ASSET_ID ASSET_ID
, PO_VENDOR_ID PO_VENDOR_ID
, ASSET_INVOICE_ID ASSET_INVOICE_ID
, FIXED_ASSETS_COST FIXED_ASSETS_COST
, DATE_EFFECTIVE DATE_EFFECTIVE
, DATE_INEFFECTIVE DATE_INEFFECTIVE
, INVOICE_TRANSACTION_ID_IN INVOICE_TRANSACTION_ID_IN
, INVOICE_TRANSACTION_ID_OUT INVOICE_TRANSACTION_ID_OUT
, DELETED_FLAG DELETED_FLAG
, PO_NUMBER PO_NUMBER
, INVOICE_NUMBER INVOICE_NUMBER
, PAYABLES_BATCH_NAME PAYABLES_BATCH_NAME
, PAYABLES_CODE_COMBINATION_ID PAYABLES_CODE_COMBINATION_ID
, FEEDER_SYSTEM_NAME FEEDER_SYSTEM_NAME
, CREATE_BATCH_DATE CREATE_BATCH_DATE
, CREATE_BATCH_ID CREATE_BATCH_ID
, INVOICE_DATE INVOICE_DATE
, PAYABLES_COST PAYABLES_COST
, POST_BATCH_ID POST_BATCH_ID
, INVOICE_ID INVOICE_ID
, AP_DISTRIBUTION_LINE_NUMBER AP_DISTRIBUTION_LINE_NUMBER
, PAYABLES_UNITS PAYABLES_UNITS
, SPLIT_MERGED_CODE SPLIT_MERGED_CODE
, DESCRIPTION DESCRIPTION
, PARENT_MASS_ADDITION_ID PARENT_MASS_ADDITION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE ATTRIBUTE_CATEGORY_CODE
, UNREVALUED_COST UNREVALUED_COST
, MERGED_CODE MERGED_CODE
, SPLIT_CODE SPLIT_CODE
, MERGE_PARENT_MASS_ADDITIONS_ID MERGE_PARENT_MASS_ADDITIONS_ID
, SPLIT_PARENT_MASS_ADDITIONS_ID SPLIT_PARENT_MASS_ADDITIONS_ID
, PROJECT_ASSET_LINE_ID PROJECT_ASSET_LINE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, DEPRECIATE_IN_GROUP_FLAG DEPRECIATE_IN_GROUP_FLAG
, MATERIAL_INDICATOR_FLAG MATERIAL_INDICATOR_FLAG
, PRIOR_SOURCE_LINE_ID PRIOR_SOURCE_LINE_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, INVOICE_LINE_NUMBER INVOICE_LINE_NUMBER
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
FROM "FA"."FA_ASSET_INVOICES"