Product: | OFA - Assets |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.FA_ASSET_INVOICES_MRC_V |
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)