VIEW: APPS.AR_ADJ_DIST_UPG_V

Source

View Text - Preformatted

SELECT ard.LINE_ID , ard.SOURCE_ID , ard.SOURCE_TABLE , ard.SOURCE_TYPE , 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.ref_account_class , ard.activity_bucket , ard.FROM_AMOUNT_DR , ard.FROM_AMOUNT_CR , ard.FROM_ACCTD_AMOUNT_DR , ard.FROM_ACCTD_AMOUNT_CR , ard.REF_DIST_CCID , 'AR_DISTRIBUTIONS' , NVL(ard.ref_mf_dist_flag,'N') FROM ar_distributions_all ard, ar_adjustments_all adj WHERE adj.upgrade_method IN ('R12', '11I','11IMFAR') AND adj.adjustment_id = ard.source_id AND ard.source_table = 'ADJ' UNION SELECT ar_num_ran_pkg.num_random , psd.adjustment_id , 'ADJ' , adj.type , psd.mf_adjustment_ccid , DECODE(sign(psd.AMOUNT),-1,abs(psd.AMOUNT),NULL) , DECODE(sign(psd.AMOUNT),1,abs(psd.AMOUNT),NULL) , DECODE(sign(psd.AMOUNT),-1,abs(psd.AMOUNT),NULL) , DECODE(sign(psd.AMOUNT),1,abs(psd.AMOUNT),NULL) , adj.ORG_ID , NULL , NULL , trx.invoice_currency_code , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , ctlgd.CUSTOMER_TRX_LINE_ID , psd.cust_trx_line_gl_dist_id , NULL , ctlgd.account_class , DECODE(ctlgd.account_class,'REV','LINE', 'CB' ,'LINE', 'TAX','TAX' , 'FREIGHT','FREIGHT' ,'LINE') , NULL , NULL , NULL , NULL , psd.mf_adjustment_ccid , 'PSA_MF_ADJ_DIST_ALL' , 'Y' FROM psa_mf_adj_dist_all psd, ar_adjustments_all adj, ra_customer_trx_all trx, ra_cust_trx_line_gl_dist_all ctlgd WHERE adj.upgrade_method = '11IMFAR' AND adj.adjustment_id = psd.adjustment_id AND NVL(psd.amount,0) <> 0 AND adj.customer_trx_id = trx.customer_trx_id AND psd.cust_trx_line_gl_dist_id = ctlgd.cust_trx_line_gl_dist_id

View Text - HTML Formatted

SELECT ARD.LINE_ID
, ARD.SOURCE_ID
, ARD.SOURCE_TABLE
, ARD.SOURCE_TYPE
, 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.REF_ACCOUNT_CLASS
, ARD.ACTIVITY_BUCKET
, ARD.FROM_AMOUNT_DR
, ARD.FROM_AMOUNT_CR
, ARD.FROM_ACCTD_AMOUNT_DR
, ARD.FROM_ACCTD_AMOUNT_CR
, ARD.REF_DIST_CCID
, 'AR_DISTRIBUTIONS'
, NVL(ARD.REF_MF_DIST_FLAG
, 'N')
FROM AR_DISTRIBUTIONS_ALL ARD
, AR_ADJUSTMENTS_ALL ADJ
WHERE ADJ.UPGRADE_METHOD IN ('R12'
, '11I'
, '11IMFAR')
AND ADJ.ADJUSTMENT_ID = ARD.SOURCE_ID
AND ARD.SOURCE_TABLE = 'ADJ' UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.ADJUSTMENT_ID
, 'ADJ'
, ADJ.TYPE
, PSD.MF_ADJUSTMENT_CCID
, DECODE(SIGN(PSD.AMOUNT)
, -1
, ABS(PSD.AMOUNT)
, NULL)
, DECODE(SIGN(PSD.AMOUNT)
, 1
, ABS(PSD.AMOUNT)
, NULL)
, DECODE(SIGN(PSD.AMOUNT)
, -1
, ABS(PSD.AMOUNT)
, NULL)
, DECODE(SIGN(PSD.AMOUNT)
, 1
, ABS(PSD.AMOUNT)
, NULL)
, ADJ.ORG_ID
, NULL
, NULL
, TRX.INVOICE_CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, CTLGD.CUSTOMER_TRX_LINE_ID
, PSD.CUST_TRX_LINE_GL_DIST_ID
, NULL
, CTLGD.ACCOUNT_CLASS
, DECODE(CTLGD.ACCOUNT_CLASS
, 'REV'
, 'LINE'
, 'CB'
, 'LINE'
, 'TAX'
, 'TAX'
, 'FREIGHT'
, 'FREIGHT'
, 'LINE')
, NULL
, NULL
, NULL
, NULL
, PSD.MF_ADJUSTMENT_CCID
, 'PSA_MF_ADJ_DIST_ALL'
, 'Y'
FROM PSA_MF_ADJ_DIST_ALL PSD
, AR_ADJUSTMENTS_ALL ADJ
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE ADJ.UPGRADE_METHOD = '11IMFAR'
AND ADJ.ADJUSTMENT_ID = PSD.ADJUSTMENT_ID
AND NVL(PSD.AMOUNT
, 0) <> 0
AND ADJ.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID