SELECT i116931 as E116931,i117065 as E117065,i117222 as E117222,i118369 as E118369,i118976 as E118976,i119001 as E119001,i119017 as E119017,i119932 as E119932,i119939 as E119939,i119946 as E119946,i119953 as E119953,i119957 as E119957,i119966 as E119966,i120420 as E120420,i120479 as E120479,i120489 as E120489,i121258 as E121258,SUM(i121258) as E121258_SUM,AVG(i118976) as E118976_AVG,AVG(i118109) as E118109_AVG FROM ( SELECT GLOBAL_ATTRIBUTE12 AS i118488, GLOBAL_ATTRIBUTE13 AS i118509, PROJECT_ACCOUNTING_CONTEXT AS i119713, PROJECT_ID AS i119715, QUANTITY_INVOICED AS i119737, QUANTITY_UNENCUMBERED AS i119740, QUANTITY_VARIANCE AS i119741, PROGRAM_APPLICATION_ID AS i119680, PROGRAM_ID AS i119695, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i120834, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i120766, INVOICE_ID AS i119011, INVOICE_INCLUDES_PREPAY_FLAG AS i119016, INVOICE_PRICE_VARIANCE AS i119023, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i120698, INVENTORY_TRANSFER_STATUS AS i118975, INVOICE_DISTRIBUTION_ID AS i119006, INCOME_TAX_REGION AS i118915, GMS_BURDENABLE_RAW_COST AS i118874, COMPANY_PREPAID_INVOICE_ID AS i117734, ATTRIBUTE6 AS i117401, GLOBAL_ATTRIBUTE10 AS i118444, GLOBAL_ATTRIBUTE11 AS i118467, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121536, JE_BATCH_ID AS i119059, PO_DISTRIBUTION_ID AS i119576, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121462, decode(ACCOUNTING_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(ACCOUNTING_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i120561, decode(ACCOUNTING_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(ACCOUNTING_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i120565, decode(ACCOUNTING_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(ACCOUNTING_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i120569, decode(ACCOUNTING_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(ACCOUNTING_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i120573, CANCELLATION_FLAG AS i117647, CASH_JE_BATCH_ID AS i117653, CASH_POSTED_FLAG AS i117654, CC_REVERSAL_FLAG AS i117663, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i120902, ATTRIBUTE15 AS i117221, ATTRIBUTE14 AS i117196, ATTRIBUTE2 AS i117266, AWARD_ID AS i117531, AWT_FLAG AS i117533, AWT_GROSS_AMOUNT AS i117535, AWT_GROUP_ID AS i117536, AWT_INVOICE_ID AS i117542, AWT_INVOICE_PAYMENT_ID AS i117543, AWT_ORIGIN_GROUP_ID AS i117544, AWT_TAX_RATE_ID AS i117548, GLOBAL_ATTRIBUTE_CATEGORY AS i118398, PERIOD_NAME AS i119535, WEB_PARAMETER_ID AS i120539, USSGL_TRANSACTION_CODE AS i120425, USSGL_TRX_CODE_CONTEXT AS i120447, VAT_CODE AS i120456, TYPE_1099 AS i120402, UNIT_PRICE AS i120409, UPGRADE_BASE_POSTED_AMT AS i120413, UPGRADE_POSTED_AMT AS i120414, PA_ADDITION_FLAG AS i119406, PA_CC_AR_INVOICE_ID AS i119407, PA_CC_AR_INVOICE_LINE_NUM AS i119408, PA_CC_PROCESSED_CODE AS i119409, PACKET_ID AS i119410, PA_CMT_XFACE_FLAG AS i119411, PA_QUANTITY AS i119414, PARENT_INVOICE_ID AS i119419, PARENT_REVERSAL_ID AS i119421, BASE_QUANTITY_VARIANCE AS i117590, BATCH_ID AS i117592, BASE_INVOICE_PRICE_VARIANCE AS i117589, FULLY_PAID_ACCTD_FLAG AS i118313, TAX_RECOVERY_OVERRIDE_FLAG AS i120186, TAX_RECOVERY_RATE AS i120187, OTHER_INVOICE_ID AS i119398, GLOBAL_ATTRIBUTE5 AS i118756, GLOBAL_ATTRIBUTE6 AS i118779, ORG_ID AS i119359, MRC_BASE_AMOUNT AS i119287, MRC_BASE_INV_PRICE_VARIANCE AS i119289, MRC_DIST_CODE_COMBINATION_ID AS i119290, MRC_EXCHANGE_DATE AS i119291, MRC_EXCHANGE_RATE AS i119293, MRC_EXCHANGE_RATE_TYPE AS i119295, MRC_EXCHANGE_RATE_VARIANCE AS i119297, MRC_RATE_VAR_CCID AS i119299, MRC_RECEIPT_CONVERSION_RATE AS i119300, GLOBAL_ATTRIBUTE3 AS i118709, GLOBAL_ATTRIBUTE4 AS i118733, DIST_CODE_COMBINATION_ID AS i118093, DIST_MATCH_TYPE AS i118094, DISTRIBUTION_LINE_NUMBER AS i118095, GLOBAL_ATTRIBUTE20 AS i118679, ATTRIBUTE9 AS i117484, MATCHED_UOM_LOOKUP_CODE AS i119251, MATCH_STATUS_FLAG AS i119264, MERCHANT_DOCUMENT_NUMBER AS i119270, MERCHANT_NAME AS i119271, MERCHANT_REFERENCE AS i119272, MERCHANT_TAXPAYER_ID AS i119273, MERCHANT_TAX_REG_NUMBER AS i119274, GLOBAL_ATTRIBUTE19 AS i118635, GLOBAL_ATTRIBUTE2 AS i118656, LAST_UPDATED_BY AS i119148, DESCRIPTION AS i118055, DAILY_AMOUNT AS i118021, LINE_GROUP_NUMBER AS i119222, LINE_TYPE_LOOKUP_CODE AS i119229, LAST_UPDATE_LOGIN AS i119182, GLOBAL_ATTRIBUTE17 AS i118593, GLOBAL_ATTRIBUTE18 AS i118614, REVERSAL_FLAG AS i119882, REQ_DISTRIBUTION_ID AS i119828, REQUEST_ID AS i119831, ASSETS_ADDITION_FLAG AS i117031, ASSETS_TRACKING_FLAG AS i117032, ATTRIBUTE_CATEGORY AS i117040, REFERENCE_1 AS i119793, REFERENCE_2 AS i119797, RCV_TRANSACTION_ID AS i119750, RECEIPT_CONVERSION_RATE AS i119757, RECEIPT_CURRENCY_AMOUNT AS i119758, RECEIPT_CURRENCY_CODE AS i119759, RATE_VAR_CODE_COMBINATION_ID AS i119749, RECEIPT_MISSING_FLAG AS i119767, RECEIPT_REQUIRED_FLAG AS i119770, RECEIPT_VERIFIED_FLAG AS i119772, ATTRIBUTE4 AS i117343, ATTRIBUTE5 AS i117372, ATTRIBUTE1 AS i117064, ATTRIBUTE10 AS i117093, GLOBAL_ATTRIBUTE14 AS i118530, GLOBAL_ATTRIBUTE15 AS i118551, ATTRIBUTE3 AS i117313, PRICE_ADJUSTMENT_FLAG AS i119643, PRICE_CORRECT_INV_ID AS i119644, PRICE_CORRECT_QTY AS i119645, PRICE_VAR_CODE_COMBINATION_ID AS i119649, PREPAY_TAX_PARENT_ID AS i119635, GLOBAL_ATTRIBUTE8 AS i118825, GLOBAL_ATTRIBUTE9 AS i118848, POSTED_AMOUNT AS i119606, POSTED_BASE_AMOUNT AS i119607, POSTED_FLAG AS i119609, PREPAY_AMOUNT_REMAINING AS i119626, PREPAY_DISTRIBUTION_ID AS i119632, AMOUNT_TO_POST AS i116988, AMOUNT_ENCUMBERED AS i116968, AMOUNT_INCLUDES_TAX_FLAG AS i116969, AWT_WITHHELD_AMT AS i117551, BASE_AMOUNT AS i117585, BASE_AMOUNT_ENCUMBERED AS i117587, BASE_AMOUNT_TO_POST AS i117588, GLOBAL_ATTRIBUTE1 AS i118421, ATTRIBUTE13 AS i117171, GLOBAL_ATTRIBUTE7 AS i118802, FINAL_MATCH_FLAG AS i118270, EXCHANGE_RATE_TYPE AS i118225, EXCHANGE_RATE_VARIANCE AS i118234, EXPENDITURE_ORGANIZATION_ID AS i118244, EXPENDITURE_TYPE AS i118246, EXPENSE_GROUP AS i118251, ENCUMBERED_FLAG AS i118186, EXCHANGE_DATE AS i118207, EXCHANGE_RATE AS i118216, TASK_ID AS i120148, TAX_CALCULATED_FLAG AS i120156, TAX_CODE_ID AS i120162, TAX_CODE_OVERRIDE_FLAG AS i120164, TAX_RECOVERABLE_FLAG AS i120185, STAT_AMOUNT AS i120106, ATTRIBUTE7 AS i117430, ATTRIBUTE8 AS i117457, ATTRIBUTE11 AS i117120, ATTRIBUTE12 AS i117146, SET_OF_BOOKS_ID AS i120001, GLOBAL_ATTRIBUTE16 AS i118572, JUSTIFICATION AS i119091, LAST_UPDATE_DATE AS i119110, AMOUNT AS i116931, ADJUSTMENT_REASON AS i116909, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121227, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121241, NVL2(EXCHANGE_RATE,EXCHANGE_RATE*AMOUNT,NVL(AMOUNT,0)) AS i121258, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121199, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121213, CREATION_DATE AS i117850, CREDIT_CARD_TRX_ID AS i117889, CREATED_BY AS i117808, COUNTRY_OF_SUPPLY AS i117778, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121684, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121610, ACCOUNTING_DATE AS i116807, ACCOUNTING_EVENT_ID AS i116809, ACCRUAL_POSTED_FLAG AS i116815, ACCTS_PAY_CODE_COMBINATION_ID AS i116828, SUBSTR(ATTRIBUTE1,1,6) AS i171794, EXPENDITURE_ITEM_DATE AS i355401, SUBSTR(ATTRIBUTE1,1,9) AS i434912, TO_DATE(SUBSTR(ATTRIBUTE1,11),'YYYY/MM/DD HH24:MI:SS') AS i434915, SUBSTR(ATTRIBUTE13,2,3) AS i434919, TO_NUMBER(SUBSTR(ATTRIBUTE13,6)) AS i434923 FROM APPS.AP_INVOICE_DISTRIBUTIONS ) o116664, ( SELECT GLOBAL_ATTRIBUTE12 AS i118489, GLOBAL_ATTRIBUTE13 AS i118510, PROJECT_ACCOUNTING_CONTEXT AS i119714, PROJECT_ID AS i119716, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i120836, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i120768, INVOICE_ID AS i119012, INVOICE_NUM AS i119017, INVOICE_TYPE_LOOKUP_CODE AS i119026, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i120700, INVOICE_AMOUNT AS i118976, INVOICE_CURRENCY_CODE AS i118985, INVOICE_DATE AS i119001, INVOICE_DISTRIBUTION_TOTAL AS i119007, ATTRIBUTE6 AS i117402, GLOBAL_ATTRIBUTE10 AS i118445, GLOBAL_ATTRIBUTE11 AS i118468, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121538, PO_HEADER_ID AS i119577, decode(INVOICE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(INVOICE_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121430, decode(INVOICE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(INVOICE_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121438, decode(INVOICE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(INVOICE_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121446, decode(INVOICE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(INVOICE_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121454, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121464, CANCELLED_AMOUNT AS i117648, CANCELLED_BY AS i117649, decode(CREATION_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(CREATION_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i120904, ATTRIBUTE14 AS i117197, ATTRIBUTE15 AS i117222, ATTRIBUTE2 AS i117267, AUTHORIZED_BY AS i117513, AUTO_TAX_CALC_FLAG AS i117523, AWARD_ID AS i117532, AWT_FLAG AS i117534, AWT_GROUP_ID AS i117537, GL_DATE AS i118369, GLOBAL_ATTRIBUTE_CATEGORY AS i118399, PAYMENT_STATUS_FLAG AS i119487, PAY_CURR_INVOICE_AMOUNT AS i119443, PAY_GROUP_LOOKUP_CODE AS i119449, PAYMENT_AMOUNT_TOTAL AS i119456, PAYMENT_CROSS_RATE AS i119457, PAYMENT_CROSS_RATE_TYPE AS i119460, PAYMENT_CURRENCY_CODE AS i119461, PAYMENT_METHOD_LOOKUP_CODE AS i119468, VOUCHER_NUM AS i120515, WFAPPROVAL_STATUS AS i120540, VENDOR_ID AS i120468, VENDOR_PREPAY_AMOUNT AS i120491, VENDOR_SITE_ID AS i120499, USSGL_TRANSACTION_CODE AS i120426, USSGL_TRX_CODE_CONTEXT AS i120448, VAT_CODE AS i120457, PA_DEFAULT_DIST_CCID AS i119412, PAID_ON_BEHALF_EMPLOYEE_ID AS i119413, PA_QUANTITY AS i119415, BATCH_ID AS i117593, FREIGHT_AMOUNT AS i118297, TEMP_CANCELLED_AMOUNT AS i120205, TERMS_DATE AS i120214, TERMS_ID AS i120220, ORIGINAL_PREPAYMENT_AMOUNT AS i119383, GLOBAL_ATTRIBUTE5 AS i118757, GLOBAL_ATTRIBUTE6 AS i118780, ORG_ID AS i119360, MRC_BASE_AMOUNT AS i119288, MRC_EXCHANGE_DATE AS i119292, MRC_EXCHANGE_RATE AS i119294, MRC_EXCHANGE_RATE_TYPE AS i119296, DOC_SEQUENCE_VALUE AS i118109, DOC_SEQUENCE_ID AS i118104, GLOBAL_ATTRIBUTE3 AS i118710, GLOBAL_ATTRIBUTE4 AS i118734, DISCOUNT_AMOUNT_TAKEN AS i118075, DOC_CATEGORY_CODE AS i118101, GLOBAL_ATTRIBUTE20 AS i118680, ATTRIBUTE9 AS i117485, GLOBAL_ATTRIBUTE19 AS i118636, GLOBAL_ATTRIBUTE2 AS i118657, LAST_UPDATED_BY AS i119149, DESCRIPTION AS i118056, SOURCE AS i120082, LAST_UPDATE_LOGIN AS i119183, GLOBAL_ATTRIBUTE18 AS i118615, GLOBAL_ATTRIBUTE17 AS i118594, REQUESTER_ID AS i119830, ATTRIBUTE_CATEGORY AS i117041, RECURRING_PAYMENT_ID AS i119787, REFERENCE_1 AS i119794, REFERENCE_2 AS i119798, ATTRIBUTE4 AS i117344, ATTRIBUTE5 AS i117373, ATTRIBUTE1 AS i117065, ATTRIBUTE10 AS i117094, GLOBAL_ATTRIBUTE14 AS i118531, GLOBAL_ATTRIBUTE15 AS i118552, ATTRIBUTE3 AS i117314, PRE_WITHHOLDING_AMOUNT AS i119642, GLOBAL_ATTRIBUTE8 AS i118826, GLOBAL_ATTRIBUTE9 AS i118849, POSTING_STATUS AS i119614, PREPAY_FLAG AS i119633, AMT_DUE_CCARD_COMPANY AS i116992, AMT_DUE_EMPLOYEE AS i116993, APPROVAL_DESCRIPTION AS i117017, APPROVAL_ITERATION AS i117018, APPROVAL_READY_FLAG AS i117019, APPROVAL_STATUS AS i117020, APPROVED_AMOUNT AS i117021, AMOUNT_PAID AS i116983, BASE_AMOUNT AS i117586, decode(GL_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(GL_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121294, decode(GL_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(GL_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121310, decode(GL_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(GL_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121326, decode(GL_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(GL_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121342, GLOBAL_ATTRIBUTE1 AS i118422, ATTRIBUTE13 AS i117172, GLOBAL_ATTRIBUTE7 AS i118803, EXCHANGE_RATE_TYPE AS i118226, EXCLUSIVE_PAYMENT_FLAG AS i118239, EXPENDITURE_ORGANIZATION_ID AS i118245, EXPENDITURE_TYPE AS i118247, EXCHANGE_DATE AS i118208, EXCHANGE_RATE AS i118217, TASK_ID AS i120149, TAX_AMOUNT AS i120155, ATTRIBUTE7 AS i117431, ATTRIBUTE8 AS i117458, ATTRIBUTE11 AS i117121, ATTRIBUTE12 AS i117147, SET_OF_BOOKS_ID AS i120002, GLOBAL_ATTRIBUTE16 AS i118573, LAST_UPDATE_DATE AS i119111, AMOUNT_APPLICABLE_TO_DISCOUNT AS i116943, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121229, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121243, NVL2(EXCHANGE_RATE,EXCHANGE_RATE*INVOICE_AMOUNT,INVOICE_AMOUNT) AS i121261, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121201, decode(EXCHANGE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(EXCHANGE_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121215, CREATION_DATE AS i117851, CREATED_BY AS i117809, decode(TERMS_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(TERMS_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i122158, decode(TERMS_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(TERMS_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i122164, decode(TERMS_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(TERMS_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i122170, decode(TERMS_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(TERMS_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i122176, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121686, decode(LAST_UPDATE_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(LAST_UPDATE_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121612, ACCTS_PAY_CODE_COMBINATION_ID AS i116829, GOODS_RECEIVED_DATE AS i272554, INVOICE_RECEIVED_DATE AS i272555 FROM APPS.AP_INVOICES ) o116665, ( SELECT START_DATE AS i120100, decode(START_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(START_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i122110, decode(START_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(START_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i122118, decode(START_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(START_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i122126, decode(START_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(START_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i122134, USER_ID AS i120416, USER_NAME AS i120420, ENCRYPTED_FOUNDATION_PASSWORD AS i118183, END_DATE AS i118189, decode(END_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(END_DATE,'DD'),'DD') || '190001','DDYYYYMM')) AS i121164, decode(END_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(END_DATE,'MM'),'MM') || '1900','MMYYYY')) AS i121172, decode(END_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(END_DATE,'Q'),'MM') || '1900','MMYYYY')) AS i121180, decode(END_DATE,null,to_date(null, 'MMDDYYYY'),to_date(to_char(trunc(END_DATE,'YYYY'),'YYYY') || '01','YYYYMM')) AS i121188 FROM APPS.FND_USER_VIEW ) o116679, ( SELECT HOLD_ALL_PAYMENTS_FLAG AS i118884, AUTO_CALCULATE_INTEREST_FLAG AS i117514, AVAILABLE_PREPAYS AS i117530, AWT_GROUP_ID AS i117538, VENDOR_TYPE_LOOKUP_CODE AS i120504, VAT_REGISTRATION_NUM AS i120461, VENDOR_ID AS i120473, VENDOR_NAME AS i120479, VENDOR_NUMBER AS i120489, TYPE_1099 AS i120403, TOTAL_PREPAYS AS i120299, NUM_ACTIVE_PAY_SITES AS i119326, NUM_INACTIVE_PAY_SITES AS i119328, NUM_1099 AS i119332, EMPLOYEE_ID AS i118174, ENABLED_FLAG AS i118181, ALLOW_AWT_FLAG AS i116917, ACTIVE_FLAG AS i116836 FROM APPS.PO_VENDORS_AP_V ) o116689, ( SELECT CODE_COMBINATION_ID AS i117714, CONCATENATED_SEGMENTS AS i117741, SEGMENT3_DESCRIPTION AS i119943, SEGMENT4 AS i119946, SEGMENT4_DESCRIPTION AS i119950, SEGMENT5 AS i119953, SEGMENT5_DESCRIPTION AS i119957, SEGMENT6 AS i119960, SEGMENT6_DESCRIPTION AS i119963, SEGMENT7 AS i119966, SEGMENT7_DESCRIPTION AS i119969, SEGMENT8 AS i119972, SEGMENT8_DESCRIPTION AS i119976, SEGMENT9 AS i119979, SEGMENT9_DESCRIPTION AS i119983, SEGMENT1 AS i119925, SEGMENT1_DESCRIPTION AS i119929, SEGMENT2 AS i119932, SEGMENT2_DESCRIPTION AS i119936, SEGMENT3 AS i119939, SUBSTR(SEGMENT5_DESCRIPTION,1,INSTR(SEGMENT5_DESCRIPTION,'/',1,1)-1) AS i121760, SET_OF_BOOKS_ID AS i137319, SEGMENT4||' - '||SEGMENT4_DESCRIPTION AS i200685 FROM APPS.XXGL_CODE_COMBINATIONS_V WHERE (SET_OF_BOOKS_ID = TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'))) ) o116718 WHERE ( (i117714 = i118093) and (i119012 = i119011) and (i117809 = i120416(+)) and (i120473 = i120468)) AND (o116665.i118369 BETWEEN :"GL DATE DU" AND :"GL DATE AU" AND 1 = 1 ) GROUP BY i116931, i117065, i117222, i118369, i118976, i119001, i119017, i119932, i119939, i119946, i119953, i119957, i119966, i120420, i120479, i120489, i121258;