APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 647: ra_cust_trx_line_gl_dist_all ctlgd

643: ar_receivable_applications_all app,
644: ar_system_parameters_all ars,
645: ra_customer_trx_all trx,
646: ra_customer_trx_lines_all ctl,
647: ra_cust_trx_line_gl_dist_all ctlgd
648: WHERE evt.event_type_code IN ('RECP_CREATE' ,'RECP_UPDATE' ,
649: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
650: 'CM_CREATE' ,'CM_UPDATE' )
651: AND evt.application_id = 222

Line 710: ra_cust_trx_line_gl_dist_all ctlgd

706: AND NOT EXISTS ( SELECT '1'
707: FROM psa_trx_types_all psa
708: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
709: ra_customer_trx_lines_all ctl,
710: ra_cust_trx_line_gl_dist_all ctlgd
711: WHERE trx.customer_trx_id = ctl.customer_trx_id
712: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
713: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
714: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')

Line 946: ra_cust_trx_line_gl_dist_all ctlgd

942: AND app.customer_trx_id = inv.customer_trx_id
943: AND inv.cust_trx_type_id = psa.psa_trx_type_id
944: AND app.upgrade_method IS NULL) trx,
945: ra_customer_trx_lines_all ctl,
946: ra_cust_trx_line_gl_dist_all ctlgd
947: WHERE trx.customer_trx_id = ctl.customer_trx_id
948: AND ctl.customer_trx_line_id = ctlgd.customer_trx_line_id
949: AND ctl.line_type IN ('LINE','TAX','FREIGHT','CHARGES','CB')
950: AND ctlgd.account_class IN ('REV','SUSPENSE','UNBILL','UNEARN','FREIGHT','TAX')

Line 1749: ra_cust_trx_line_gl_dist_all ctlgd

1745: MAX(to_currency) invoice_currency_code
1746: FROM ra_ar_gt
1747: GROUP BY ref_customer_trx_id, to_currency) trx,
1748: ra_customer_trx_lines_all ctl,
1749: ra_cust_trx_line_gl_dist_all ctlgd
1750: WHERE adj.customer_trx_id = trx.ref_customer_trx_id
1751: AND adj.status = 'A'
1752: AND adj.postable = 'Y'
1753: AND adj.upgrade_method = '11IMFAR'