APPS.AR_AGING_BUCKETS_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 1727: and lk.source_distribution_type(+) = ''RA_CUST_TRX_LINE_GL_DIST_ALL''

1723: p_rep_where_cls := p_rep_where_cls || '
1724: and types.cust_trx_type_id = ps.cust_trx_type_id
1725: and types.org_id = ps.org_id
1726: and gld.cust_trx_line_gl_dist_id = lk.source_distribution_id_num_1(+)
1727: and lk.source_distribution_type(+) = ''RA_CUST_TRX_LINE_GL_DIST_ALL''
1728: and lk.application_id(+) = 222
1729: and ae.application_id(+) = 222
1730: and lk.ae_header_id = ae.ae_header_id(+)
1731: and lk.ae_line_num = ae.ae_line_num(+)

Line 2359: ra_cust_trx_line_gl_dist gld,

2355: hz_cust_site_uses site,
2356: hz_cust_acct_sites acct_site,
2357: hz_party_sites party_site,
2358: hz_locations loc,
2359: ra_cust_trx_line_gl_dist gld,
2360: ar_dispute_history dh,
2361: gl_code_combinations c '||l_rep_spec_from_list ||'
2362: where ps.customer_site_use_id = site.site_use_id
2363: and ps.customer_id = cust_acct.cust_account_id

Line 2815: select /*+ leading(ext) index(ctlgd RA_CUST_TRX_LINE_GL_DIST_N6)*/

2811: ext.amt_due_remaining
2812:
2813: UNION ALL
2814:
2815: select /*+ leading(ext) index(ctlgd RA_CUST_TRX_LINE_GL_DIST_N6)*/
2816: ctlgd.event_id,
2817: ext.payment_schedule_id,
2818: ext.amt_due_remaining,
2819: 'CTLGD' source_identifier

Line 2822: ra_cust_trx_line_gl_dist ctlgd

2818: ext.amt_due_remaining,
2819: 'CTLGD' source_identifier
2820: from ar_aging_extract ext,
2821: ar_payment_schedules ps,
2822: ra_cust_trx_line_gl_dist ctlgd
2823: where ext.parent_request_id = pg_parent_request_id
2824: and ext.worker_id = pg_worker_id
2825: and ext.payment_schedule_id = ps.payment_schedule_id
2826: and ps.customer_trx_id = ctlgd.customer_trx_id