AR_XLA_ARD_LINES_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

LINE_ID SOURCE_ID SOURCE_TABLE SOURCE_TYPE GL_SL_LINK_ID GL_SL_LINK_TABLE CODE_COMBINATION_ID UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_CR UNROUNDED_ACCOUNTED_DR UNROUNDED_ACCOUNTED_CR ORG_ID SOURCE_TABLE_SECONDARY SOURCE_ID_SECONDARY CURRENCY_CODE CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_DATE TAXABLE_ENTERED_DR TAXABLE_ENTERED_CR TAXABLE_ACCOUNTED_DR TAXABLE_ACCOUNTED_CR TAX_LINK_ID THIRD_PARTY_ID THIRD_PARTY_SUB_ID REVERSED_SOURCE_ID TAX_CODE_ID LOCATION_SEGMENT_ID SOURCE_TYPE_SECONDARY TAX_GROUP_CODE_ID REF_CUSTOMER_TRX_LINE_ID REF_CUST_TRX_LINE_GL_DIST_ID REF_LINE_ID FROM_AMOUNT_DR FROM_AMOUNT_CR FROM_ACCTD_AMOUNT_DR FROM_ACCTD_AMOUNT_CR REF_ACCOUNT_CLASS ACTIVITY_BUCKET REF_DIST_CCID REF_MF_DIST_FLAG AE_HEADER_ID CASH_RECEIPT_ID ACCOUNTING_DATE GL_POSTED_DATE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE

Query

SQL_Statement

SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , DECODE( ae.accounting_class_code, 'UNAPP','UNAPP', ard.source_type) SOURCE_TYPE, ae.GL_SL_LINK_ID , ae.GL_SL_LINK_TABLE , ae.code_combination_id , lk.unrounded_entered_dr , lk.unrounded_entered_cr , lk.unrounded_accounted_dr , lk.unrounded_accounted_cr , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , NULL FROM_AMOUNT_DR, lk.unrounded_accounted_cr FROM_AMOUNT_CR, NULL FROM_ACCTD_AMOUNT_DR, NULL FROM_ACCTD_AMOUNT_CR, ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , ae.ae_header_id , crh.cash_receipt_id , hd.accounting_date , crh.gl_posted_date , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard , xla_distribution_links lk , xla_ae_lines ae , ar_cash_receipt_history_all crh, ar_cash_receipts_all cr , xla_ae_headers hd WHERE ard.source_table = 'CRH' AND ard.source_id = crh.cash_receipt_history_id AND ard.line_id = lk.source_distribution_id_num_1 AND lk.application_id = 222 AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND ae.application_id = 222 AND lk.ae_header_id = ae.ae_header_id AND lk.ae_line_num = ae.ae_line_num AND lk.ae_header_id = hd.ae_header_id AND crh.cash_receipt_id = cr.cash_receipt_id AND cr.set_of_books_id = hd.ledger_id AND crh.event_id IS NOT NULL AND ae.accounting_class_code IN ( 'CASH', 'REMITTANCE', 'CONFIRMATION', 'FV_CASH_CR', 'FV_CASH_DR', 'RECEIVABLE','BILL_REC', 'FREIGHT', 'TAX', 'DEFERRED_TAX', 'REVENUE', 'UNEARNED_REVENUE', 'UNBILL', 'EDISC', 'EDISC_NON_REC_TAX', 'UNEDISC', 'UNEDISC_NON_REC_TAX', 'ROUNDING', 'EXCHANGE_GAIN_LOSS', 'GAIN', 'LOSS', 'UNID', 'WRITE_OFF', 'ACC', 'BANK_CHG', 'CLAIM', 'SHORT_TERM_DEBT', 'FACTOR', 'FAC_BR', 'PMT_NET', 'PREPAY', 'REFUND', 'REM_BR', 'UNAPP') UNION SELECT /*+ index(hd XLA_AE_HEADERS_U1) */ ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , DECODE(ae.accounting_class_code,'RECEIVABLE','REC', ard.SOURCE_TYPE) , ae.GL_SL_LINK_ID , ae.GL_SL_LINK_TABLE , ae.code_combination_id , lk.unrounded_entered_dr , lk.unrounded_entered_cr , lk.unrounded_accounted_dr , lk.unrounded_accounted_cr , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , NULL , NULL , NULL , NULL , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , ae.ae_header_id , NULL , NULL , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard, xla_distribution_links lk, xla_ae_lines ae, ar_transaction_history_all th, ra_customer_trx_all trx, xla_ae_headers hd WHERE ard.source_table = 'TH' AND ard.source_id = th.transaction_history_id AND ard.line_id = lk.source_distribution_id_num_1 AND lk.application_id = 222 AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND ae.application_id = 222 AND lk.ae_header_id = ae.ae_header_id AND lk.ae_line_num = ae.ae_line_num AND lk.ae_header_id = hd.ae_header_id AND th.customer_trx_id = trx.customer_trx_id AND trx.set_of_books_id = hd.ledger_id AND th.event_id IS NOT NULL AND ae.accounting_class_code IN ( 'RECEIVABLE','BILL_REC', 'DEFERRED_TAX', 'TAX', 'UNPAID_BR', 'REM_BR', 'FAC_BR') UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , DECODE( ae.accounting_class_code, 'UNAPP','UNAPP', 'EXCHANGE_GAIN_LOSS', DECODE(SIGN(NVL(lk.unrounded_accounted_cr,0)-NVL(lk.unrounded_accounted_dr,0)), -1,'EXCH_LOSS','EXCH_GAIN'), ard.SOURCE_TYPE) , ae.GL_SL_LINK_ID , ae.GL_SL_LINK_TABLE , ae.code_combination_id , lk.unrounded_entered_dr , lk.unrounded_entered_cr , lk.unrounded_accounted_dr , lk.unrounded_accounted_cr , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , NULL , NULL , NULL , NULL , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , ae.ae_header_id , ra.cash_receipt_id , hd.accounting_date , ra.gl_posted_date , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard , xla_distribution_links lk , xla_ae_lines ae , ar_receivable_applications_all ra, xla_ae_headers hd WHERE ard.source_table = 'RA' AND ard.source_id = ra.receivable_application_id AND ard.line_id = lk.source_distribution_id_num_1 AND lk.application_id = 222 AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND ae.application_id = 222 AND lk.ae_header_id = ae.ae_header_id AND lk.ae_line_num = ae.ae_line_num AND lk.ae_header_id = hd.ae_header_id AND ra.set_of_books_id = hd.ledger_id AND ra.event_id IS NOT NULL AND ae.accounting_class_code IN ( 'CASH', 'REMITTANCE', 'CONFIRMATION', 'FV_CASH_CR', 'FV_CASH_DR', 'RECEIVABLE', 'BILL_REC','FREIGHT', 'TAX', 'DEFERRED_TAX', 'REVENUE', 'UNEARNED_REVENUE', 'UNBILL', 'EDISC', 'EDISC_NON_REC_TAX', 'UNEDISC', 'UNEDISC_NON_REC_TAX', 'ROUNDING', 'EXCHANGE_GAIN_LOSS', 'GAIN', 'LOSS', 'UNID', 'WRITE_OFF', 'ACC', 'BANK_CHG', 'CLAIM', 'SHORT_TERM_DEBT', 'FACTOR', 'FAC_BR', 'PMT_NET', 'PREPAY', 'REFUND', 'REM_BR', 'UNAPP') UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , DECODE(ae.accounting_class_code,'RECEIVABLE','REC',ard.SOURCE_TYPE) , ae.GL_SL_LINK_ID , ae.GL_SL_LINK_TABLE , ae.code_combination_id , lk.unrounded_entered_dr , lk.unrounded_entered_cr , lk.unrounded_accounted_dr , lk.unrounded_accounted_cr , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , NULL , NULL , NULL , NULL , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , ae.ae_header_id , NULL , NULL , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard , xla_distribution_links lk, xla_ae_lines ae , ar_adjustments_all adj , xla_ae_headers hd WHERE ard.source_table = 'ADJ' AND ard.source_id = adj.adjustment_id AND ard.line_id = lk.source_distribution_id_num_1 AND lk.application_id = 222 AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' AND ae.application_id = 222 AND lk.ae_header_id = ae.ae_header_id AND lk.ae_line_num = ae.ae_line_num AND lk.ae_header_id = hd.ae_header_id AND adj.set_of_books_id = hd.ledger_id AND adj.event_id IS NOT NULL AND ae.accounting_class_code IN ( 'RECEIVABLE', 'ADJ', 'CHARGES', 'TAX', 'FINCHRG_NON_REC_TAX', 'ADJ_NON_REC_TAX', 'ENDORSEMENT') UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , null GL_SL_LINK_ID , null GL_SL_LINK_TABLE , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , NULL , NULL , ra.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard, ar_receivable_applications_all ra WHERE ra.posting_control_id <> -3 AND ard.source_table = 'RA' AND ard.source_id = ra.receivable_application_id AND ra.status = 'APP' AND ra.event_id IS NULL UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , NULL , NULL , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , NULL , NULL , th.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard, ar_transaction_history_all th WHERE th.posting_control_id <> -3 AND ard.source_table = 'TH' AND ard.source_id = th.transaction_history_id AND th.event_id IS NULL UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , null GL_SL_LINK_ID , null GL_SL_LINK_TABLE , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , NULL , NULL , ra.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard, ar_receivable_applications_all ra WHERE ra.posting_control_id <> -3 AND ard.source_table = 'RA' AND ard.source_id = ra.receivable_application_id AND ra.status = 'UNAPP' AND ra.event_id IS NULL AND EXISTS (SELECT NULL FROM xla_distribution_links lk WHERE lk.source_distribution_id_num_1 = ard.line_id AND lk.application_id = 222 AND lk.source_distribution_type = 'AR_DISTRIBUTIONS_ALL' ) UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , null GL_SL_LINK_ID , null GL_SL_LINK_TABLE , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , NULL , NULL , adj.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard, ar_adjustments_all adj WHERE adj.posting_control_id <> -3 AND ard.source_table = 'ADJ' AND ard.source_id = adj.adjustment_id AND adj.event_id IS NULL UNION SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , null GL_SL_LINK_ID , null GL_SL_LINK_TABLE , ard.code_combination_id , ard.AMOUNT_DR , ard.AMOUNT_CR , ard.ACCTD_AMOUNT_DR , ard.ACCTD_AMOUNT_CR , ard.ORG_ID , ard.SOURCE_TABLE_SECONDARY , ard.SOURCE_ID_SECONDARY , ard.CURRENCY_CODE , ard.CURRENCY_CONVERSION_RATE , ard.CURRENCY_CONVERSION_TYPE , ard.CURRENCY_CONVERSION_DATE , ard.TAXABLE_ENTERED_DR , ard.TAXABLE_ENTERED_CR , ard.TAXABLE_ACCOUNTED_DR , ard.TAXABLE_ACCOUNTED_CR , ard.TAX_LINK_ID , ard.THIRD_PARTY_ID , ard.THIRD_PARTY_SUB_ID , ard.REVERSED_SOURCE_ID , ard.TAX_CODE_ID , ard.LOCATION_SEGMENT_ID , ard.SOURCE_TYPE_SECONDARY , ard.TAX_GROUP_CODE_ID , ard.REF_CUSTOMER_TRX_LINE_ID , ard.REF_CUST_TRX_LINE_GL_DIST_ID , ard.REF_LINE_ID , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_ACCOUNT_CLASS , ard.ACTIVITY_BUCKET , ard.REF_DIST_CCID , ard.REF_MF_DIST_FLAG , NULL , NULL , mcd.gl_date , NULL , ard.CREATION_DATE , ard.CREATED_BY , ard.LAST_UPDATED_BY , ard.LAST_UPDATE_DATE FROM ar_distributions_all ard, ar_misc_cash_distributions_all mcd WHERE mcd.posting_control_id <> -3 AND ard.source_table = 'MCD' AND ard.source_id = mcd.misc_cash_distribution_id AND mcd.event_id IS NULL