VIEW: APPS.AR_APP_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_receivable_applications_all app WHERE app.upgrade_method IN ('R12_NLB','R12', 'R12_11IMFAR', 'R12_11ICASH') AND app.receivable_application_id = ard.source_id AND ard.source_table = 'RA' UNION SELECT acb.cash_basis_distribution_id , acb.receivable_application_id , 'RA' , DECODE(acb.activity_bucket,'ED_LINE' ,'EDISC', 'UNED_LINE','UNEDISC', 'ED_TAX' ,'EDISC', 'UNED_TAX' ,'UNEDISC', 'ED_FRT' ,'EDISC', 'UNED_FRT' ,'UNEDISC', 'ED_CHRG' ,'EDISC', 'UNED_CHRG','UNEDISC','REC') , acb.code_combination_id , DECODE(sign(acb.AMOUNT),-1,abs(acb.amount), NULL) , DECODE(sign(acb.AMOUNT),1,abs(acb.amount),NULL) , DECODE(sign(acb.AMOUNT),-1,abs(acb.acctd_amount),NULL) , DECODE(sign(acb.AMOUNT),1,abs(acb.acctd_amount),NULL) , acb.org_id , NULL , NULL , acb.CURRENCY_CODE , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , acb.REF_CUSTOMER_TRX_LINE_ID , acb.REF_CUST_TRX_LINE_GL_DIST_ID , acb.REF_LINE_Id , acb.ref_account_class , acb.activity_bucket , DECODE(sign(acb.AMOUNT),-1,abs(acb.amount), NULL) , DECODE(sign(acb.AMOUNT),1,abs(acb.amount),NULL) , DECODE(sign(acb.AMOUNT),-1,abs(acb.acctd_amount),NULL) , DECODE(sign(acb.AMOUNT),1,abs(acb.acctd_amount),NULL) , acb.code_combination_id , 'AR_CASH_BASIS_DISTS_ALL' , 'N' FROM AR_CASH_BASIS_DISTS_ALL acb, ar_receivable_applications_all app WHERE app.upgrade_method = 'R12_11ICASH_POST' AND app.receivable_application_id = acb.receivable_application_id UNION SELECT ar_num_ran_pkg.num_random , psd.receivable_application_id , 'RA' , 'REC' , psd.mf_cash_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) , app.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') , 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) , psd.mf_cash_ccid , 'PSA_MF_RCT_DIST_ALL' , 'Y' FROM psa_mf_rct_dist_all psd, ar_receivable_applications_all app, ra_customer_trx_all trx, ra_cust_trx_line_gl_dist_all ctlgd WHERE app.upgrade_method = 'R12_11IMFAR_POST' AND app.receivable_application_id = psd.receivable_application_id AND NVL(psd.amount,0) <> 0 AND app.applied_customer_trx_id = trx.customer_trx_id AND psd.cust_trx_line_gl_dist_id = ctlgd.cust_trx_line_gl_dist_id UNION SELECT ar_num_ran_pkg.num_random , psd.receivable_application_id , 'RA' , 'EDISC' , psd.discount_ccid , DECODE(sign(psd.DISCOUNT_AMOUNT),1,abs(psd.DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.DISCOUNT_AMOUNT),-1,abs(psd.DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.DISCOUNT_AMOUNT),1,abs(psd.DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.DISCOUNT_AMOUNT),-1,abs(psd.DISCOUNT_AMOUNT),NULL) , app.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') , DECODE(sign(psd.DISCOUNT_AMOUNT),1,abs(psd.DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.DISCOUNT_AMOUNT),-1,abs(psd.DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.DISCOUNT_AMOUNT),1,abs(psd.DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.DISCOUNT_AMOUNT),-1,abs(psd.DISCOUNT_AMOUNT),NULL) , psd.discount_ccid , 'PSA_MF_RCT_DIST_ALL' , 'Y' FROM psa_mf_rct_dist_all psd, ar_receivable_applications_all app, ra_customer_trx_all trx, ra_cust_trx_line_gl_dist_all ctlgd WHERE app.upgrade_method = 'R12_11IMFAR_POST' AND app.receivable_application_id = psd.receivable_application_id AND NVL(psd.discount_amount,0) <> 0 AND app.applied_customer_trx_id = trx.customer_trx_id AND psd.cust_trx_line_gl_dist_id = ctlgd.cust_trx_line_gl_dist_id UNION SELECT ar_num_ran_pkg.num_random , psd.receivable_application_id , 'RA' , 'UEDISC' , psd.ue_discount_ccid , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),-1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),-1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , app.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') , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),-1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , DECODE(sign(psd.UE_DISCOUNT_AMOUNT),-1,abs(psd.UE_DISCOUNT_AMOUNT),NULL) , psd.ue_discount_ccid , 'PSA_MF_RCT_DIST_ALL' , 'Y' FROM psa_mf_rct_dist_all psd, ar_receivable_applications_all app, ra_customer_trx_all trx, ra_cust_trx_line_gl_dist_all ctlgd WHERE app.upgrade_method = 'R12_11IMFAR_POST' AND app.receivable_application_id = psd.receivable_application_id AND NVL(psd.ue_discount_amount,0) <> 0 AND app.applied_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_RECEIVABLE_APPLICATIONS_ALL APP
WHERE APP.UPGRADE_METHOD IN ('R12_NLB'
, 'R12'
, 'R12_11IMFAR'
, 'R12_11ICASH')
AND APP.RECEIVABLE_APPLICATION_ID = ARD.SOURCE_ID
AND ARD.SOURCE_TABLE = 'RA' UNION SELECT ACB.CASH_BASIS_DISTRIBUTION_ID
, ACB.RECEIVABLE_APPLICATION_ID
, 'RA'
, DECODE(ACB.ACTIVITY_BUCKET
, 'ED_LINE'
, 'EDISC'
, 'UNED_LINE'
, 'UNEDISC'
, 'ED_TAX'
, 'EDISC'
, 'UNED_TAX'
, 'UNEDISC'
, 'ED_FRT'
, 'EDISC'
, 'UNED_FRT'
, 'UNEDISC'
, 'ED_CHRG'
, 'EDISC'
, 'UNED_CHRG'
, 'UNEDISC'
, 'REC')
, ACB.CODE_COMBINATION_ID
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, ACB.ORG_ID
, NULL
, NULL
, ACB.CURRENCY_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, ACB.REF_CUSTOMER_TRX_LINE_ID
, ACB.REF_CUST_TRX_LINE_GL_DIST_ID
, ACB.REF_LINE_ID
, ACB.REF_ACCOUNT_CLASS
, ACB.ACTIVITY_BUCKET
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, -1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, DECODE(SIGN(ACB.AMOUNT)
, 1
, ABS(ACB.ACCTD_AMOUNT)
, NULL)
, ACB.CODE_COMBINATION_ID
, 'AR_CASH_BASIS_DISTS_ALL'
, 'N'
FROM AR_CASH_BASIS_DISTS_ALL ACB
, AR_RECEIVABLE_APPLICATIONS_ALL APP
WHERE APP.UPGRADE_METHOD = 'R12_11ICASH_POST'
AND APP.RECEIVABLE_APPLICATION_ID = ACB.RECEIVABLE_APPLICATION_ID UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.RECEIVABLE_APPLICATION_ID
, 'RA'
, 'REC'
, PSD.MF_CASH_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)
, APP.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')
, 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)
, PSD.MF_CASH_CCID
, 'PSA_MF_RCT_DIST_ALL'
, 'Y'
FROM PSA_MF_RCT_DIST_ALL PSD
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE APP.UPGRADE_METHOD = 'R12_11IMFAR_POST'
AND APP.RECEIVABLE_APPLICATION_ID = PSD.RECEIVABLE_APPLICATION_ID
AND NVL(PSD.AMOUNT
, 0) <> 0
AND APP.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.RECEIVABLE_APPLICATION_ID
, 'RA'
, 'EDISC'
, PSD.DISCOUNT_CCID
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, APP.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')
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, 1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.DISCOUNT_AMOUNT)
, -1
, ABS(PSD.DISCOUNT_AMOUNT)
, NULL)
, PSD.DISCOUNT_CCID
, 'PSA_MF_RCT_DIST_ALL'
, 'Y'
FROM PSA_MF_RCT_DIST_ALL PSD
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE APP.UPGRADE_METHOD = 'R12_11IMFAR_POST'
AND APP.RECEIVABLE_APPLICATION_ID = PSD.RECEIVABLE_APPLICATION_ID
AND NVL(PSD.DISCOUNT_AMOUNT
, 0) <> 0
AND APP.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID UNION SELECT AR_NUM_RAN_PKG.NUM_RANDOM
, PSD.RECEIVABLE_APPLICATION_ID
, 'RA'
, 'UEDISC'
, PSD.UE_DISCOUNT_CCID
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, APP.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')
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, 1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, DECODE(SIGN(PSD.UE_DISCOUNT_AMOUNT)
, -1
, ABS(PSD.UE_DISCOUNT_AMOUNT)
, NULL)
, PSD.UE_DISCOUNT_CCID
, 'PSA_MF_RCT_DIST_ALL'
, 'Y'
FROM PSA_MF_RCT_DIST_ALL PSD
, AR_RECEIVABLE_APPLICATIONS_ALL APP
, RA_CUSTOMER_TRX_ALL TRX
, RA_CUST_TRX_LINE_GL_DIST_ALL CTLGD
WHERE APP.UPGRADE_METHOD = 'R12_11IMFAR_POST'
AND APP.RECEIVABLE_APPLICATION_ID = PSD.RECEIVABLE_APPLICATION_ID
AND NVL(PSD.UE_DISCOUNT_AMOUNT
, 0) <> 0
AND APP.APPLIED_CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND PSD.CUST_TRX_LINE_GL_DIST_ID = CTLGD.CUST_TRX_LINE_GL_DIST_ID