VIEW: APPS.FA_ASSET_INVOICES_MRC_V

Source

View Text - Preformatted

SELECT FAMAI.SET_OF_BOOKS_ID , FAMAI.EXCHANGE_RATE , FAMAI.ASSET_ID , FAMAI.PO_VENDOR_ID , FAMAI.ASSET_INVOICE_ID , FAMAI.FIXED_ASSETS_COST , FAMAI.DATE_EFFECTIVE , FAMAI.DATE_INEFFECTIVE , FAMAI.INVOICE_TRANSACTION_ID_IN , FAMAI.INVOICE_TRANSACTION_ID_OUT , FAMAI.DELETED_FLAG , FAMAI.PO_NUMBER , FAMAI.INVOICE_NUMBER , FAMAI.PAYABLES_BATCH_NAME , FAMAI.PAYABLES_CODE_COMBINATION_ID , FAMAI.FEEDER_SYSTEM_NAME , FAMAI.CREATE_BATCH_DATE , FAMAI.CREATE_BATCH_ID , FAMAI.INVOICE_DATE , FAMAI.PAYABLES_COST , FAMAI.POST_BATCH_ID , FAMAI.INVOICE_ID , FAMAI.AP_DISTRIBUTION_LINE_NUMBER , FAMAI.PAYABLES_UNITS , FAMAI.SPLIT_MERGED_CODE , FAMAI.DESCRIPTION , FAMAI.PARENT_MASS_ADDITION_ID , FAMAI.LAST_UPDATE_DATE , FAMAI.LAST_UPDATED_BY , FAMAI.CREATED_BY , FAMAI.CREATION_DATE , FAMAI.LAST_UPDATE_LOGIN , FAMAI.ATTRIBUTE1 , FAMAI.ATTRIBUTE2 , FAMAI.ATTRIBUTE3 , FAMAI.ATTRIBUTE4 , FAMAI.ATTRIBUTE5 , FAMAI.ATTRIBUTE6 , FAMAI.ATTRIBUTE7 , FAMAI.ATTRIBUTE8 , FAMAI.ATTRIBUTE9 , FAMAI.ATTRIBUTE10 , FAMAI.ATTRIBUTE11 , FAMAI.ATTRIBUTE12 , FAMAI.ATTRIBUTE13 , FAMAI.ATTRIBUTE14 , FAMAI.ATTRIBUTE15 , FAMAI.ATTRIBUTE_CATEGORY_CODE , FAMAI.UNREVALUED_COST , FAMAI.MERGED_CODE , FAMAI.SPLIT_CODE , FAMAI.MERGE_PARENT_MASS_ADDITIONS_ID , FAMAI.SPLIT_PARENT_MASS_ADDITIONS_ID , FAMAI.PROJECT_ASSET_LINE_ID , FAMAI.PROJECT_ID , FAMAI.TASK_ID , FAMAI.SOURCE_LINE_ID , FAMAI.DEPRECIATE_IN_GROUP_FLAG , FAMAI.MATERIAL_INDICATOR_FLAG , FAMAI.PRIOR_SOURCE_LINE_ID, FAMAI.INVOICE_LINE_NUMBER, FAMAI.INVOICE_DISTRIBUTION_ID , FAMAI.PO_DISTRIBUTION_ID FROM FA_MC_ASSET_INVOICES FAMAI WHERE FAMAI.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)),-1)

View Text - HTML Formatted

SELECT FAMAI.SET_OF_BOOKS_ID
, FAMAI.EXCHANGE_RATE
, FAMAI.ASSET_ID
, FAMAI.PO_VENDOR_ID
, FAMAI.ASSET_INVOICE_ID
, FAMAI.FIXED_ASSETS_COST
, FAMAI.DATE_EFFECTIVE
, FAMAI.DATE_INEFFECTIVE
, FAMAI.INVOICE_TRANSACTION_ID_IN
, FAMAI.INVOICE_TRANSACTION_ID_OUT
, FAMAI.DELETED_FLAG
, FAMAI.PO_NUMBER
, FAMAI.INVOICE_NUMBER
, FAMAI.PAYABLES_BATCH_NAME
, FAMAI.PAYABLES_CODE_COMBINATION_ID
, FAMAI.FEEDER_SYSTEM_NAME
, FAMAI.CREATE_BATCH_DATE
, FAMAI.CREATE_BATCH_ID
, FAMAI.INVOICE_DATE
, FAMAI.PAYABLES_COST
, FAMAI.POST_BATCH_ID
, FAMAI.INVOICE_ID
, FAMAI.AP_DISTRIBUTION_LINE_NUMBER
, FAMAI.PAYABLES_UNITS
, FAMAI.SPLIT_MERGED_CODE
, FAMAI.DESCRIPTION
, FAMAI.PARENT_MASS_ADDITION_ID
, FAMAI.LAST_UPDATE_DATE
, FAMAI.LAST_UPDATED_BY
, FAMAI.CREATED_BY
, FAMAI.CREATION_DATE
, FAMAI.LAST_UPDATE_LOGIN
, FAMAI.ATTRIBUTE1
, FAMAI.ATTRIBUTE2
, FAMAI.ATTRIBUTE3
, FAMAI.ATTRIBUTE4
, FAMAI.ATTRIBUTE5
, FAMAI.ATTRIBUTE6
, FAMAI.ATTRIBUTE7
, FAMAI.ATTRIBUTE8
, FAMAI.ATTRIBUTE9
, FAMAI.ATTRIBUTE10
, FAMAI.ATTRIBUTE11
, FAMAI.ATTRIBUTE12
, FAMAI.ATTRIBUTE13
, FAMAI.ATTRIBUTE14
, FAMAI.ATTRIBUTE15
, FAMAI.ATTRIBUTE_CATEGORY_CODE
, FAMAI.UNREVALUED_COST
, FAMAI.MERGED_CODE
, FAMAI.SPLIT_CODE
, FAMAI.MERGE_PARENT_MASS_ADDITIONS_ID
, FAMAI.SPLIT_PARENT_MASS_ADDITIONS_ID
, FAMAI.PROJECT_ASSET_LINE_ID
, FAMAI.PROJECT_ID
, FAMAI.TASK_ID
, FAMAI.SOURCE_LINE_ID
, FAMAI.DEPRECIATE_IN_GROUP_FLAG
, FAMAI.MATERIAL_INDICATOR_FLAG
, FAMAI.PRIOR_SOURCE_LINE_ID
, FAMAI.INVOICE_LINE_NUMBER
, FAMAI.INVOICE_DISTRIBUTION_ID
, FAMAI.PO_DISTRIBUTION_ID
FROM FA_MC_ASSET_INVOICES FAMAI
WHERE FAMAI.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)