VIEW: APPS.FA_ADD_INVOICE_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(GLSB.CURRENCY_CODE,30)) FIXED_ASSETS_COST , AI.DATE_EFFECTIVE , AI.DATE_INEFFECTIVE , AI.INVOICE_TRANSACTION_ID_IN , AI.INVOICE_TRANSACTION_ID_OUT , AI.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(GLSB.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 INVOICE_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(GLSB.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 , PO.INVOICE_CURRENCY_CODE , AD.ASSET_NUMBER , AD.ASSET_TYPE , AD.TAG_NUMBER , AD.DESCRIPTION ASSET_DESCRIPTION , AD.ASSET_KEY_CCID , AD.ASSET_CATEGORY_ID , AD.LEASE_ID , CA.CATEGORY_TYPE , CA.CAPITALIZE_FLAG , AK.CONCATENATED_SEGMENTS ASSET_KEY , CK.CONCATENATED_SEGMENTS CATEGORY , AI.INVOICE_LINE_NUMBER FROM FA_ADDITIONS AD, FA_CATEGORIES_B CA, FA_CATEGORIES_B_KFV CK, FA_ASSET_KEYWORDS_KFV AK, PO_VENDORS PO, FA_ASSET_INVOICES AI, FA_BOOKS BK, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB WHERE AD.ASSET_ID = AI.ASSET_ID AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID(+) AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+) AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID(+) AND AI.DATE_INEFFECTIVE IS NULL AND PO.VENDOR_ID(+) = AI.PO_VENDOR_ID AND AI.ASSET_ID = BK.ASSET_ID AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BK.TRANSACTION_HEADER_ID_OUT IS NULL AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND BC.BOOK_CLASS = 'CORPORATE'

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(GLSB.CURRENCY_CODE
, 30)) FIXED_ASSETS_COST
, AI.DATE_EFFECTIVE
, AI.DATE_INEFFECTIVE
, AI.INVOICE_TRANSACTION_ID_IN
, AI.INVOICE_TRANSACTION_ID_OUT
, AI.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(GLSB.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 INVOICE_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(GLSB.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
, PO.INVOICE_CURRENCY_CODE
, AD.ASSET_NUMBER
, AD.ASSET_TYPE
, AD.TAG_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, AD.ASSET_KEY_CCID
, AD.ASSET_CATEGORY_ID
, AD.LEASE_ID
, CA.CATEGORY_TYPE
, CA.CAPITALIZE_FLAG
, AK.CONCATENATED_SEGMENTS ASSET_KEY
, CK.CONCATENATED_SEGMENTS CATEGORY
, AI.INVOICE_LINE_NUMBER
FROM FA_ADDITIONS AD
, FA_CATEGORIES_B CA
, FA_CATEGORIES_B_KFV CK
, FA_ASSET_KEYWORDS_KFV AK
, PO_VENDORS PO
, FA_ASSET_INVOICES AI
, FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
WHERE AD.ASSET_ID = AI.ASSET_ID
AND AD.ASSET_CATEGORY_ID = CA.CATEGORY_ID(+)
AND AD.ASSET_KEY_CCID = AK.CODE_COMBINATION_ID(+)
AND AD.ASSET_CATEGORY_ID = CK.CATEGORY_ID(+)
AND AI.DATE_INEFFECTIVE IS NULL
AND PO.VENDOR_ID(+) = AI.PO_VENDOR_ID
AND AI.ASSET_ID = BK.ASSET_ID
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.TRANSACTION_HEADER_ID_OUT IS NULL
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND BC.BOOK_CLASS = 'CORPORATE'