DBA Data[Home] [Help]

APPS.OKL_REPORT_GENERATOR_PVT dependencies on AR_DISTRIBUTIONS_ALL

Line 2142: ,ar_distributions_all rdist

2138: ,okl_trx_types_v try
2139: ,okl_strm_type_v sty
2140: -- AR Tables
2141: ,ar_adjustments_all radj
2142: ,ar_distributions_all rdist
2143: -- OLM Reconciliation Report Entities
2144: ,okl_reports_b rep
2145: ,okl_report_trx_params rtryp
2146: ,okl_rep_products_gt pdt_gt

Line 2196: AND xd.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2192: AND xe.application_id = xvl.application_id
2193: AND xvl.event_type_code = xe.event_type_code
2194: AND xd.event_id = radj.event_id
2195: AND xd.application_id = 222
2196: AND xd.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2197: AND xd.source_distribution_id_num_1 = rdist.line_id
2198: AND xd.ae_header_id = xh.ae_header_id
2199: AND xl.ae_header_id = xh.ae_header_id
2200: AND xl.ledger_id = p_ledger_id

Line 2292: ,ar_distributions_all rdist

2288: ,okl_trx_types_v try
2289: ,okl_strm_type_v sty
2290: -- AR Tables
2291: ,ar_adjustments_all radj
2292: ,ar_distributions_all rdist
2293: -- OLM Reconciliation Report Entities
2294: ,okl_reports_b rep
2295: ,okl_report_trx_params rtryp
2296: ,okl_rep_products_gt pdt_gt

Line 2351: AND xd.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2347: AND xe.application_id = xvl.application_id
2348: AND xvl.event_type_code = xe.event_type_code
2349: AND xd.event_id = radj.event_id
2350: AND xd.application_id = 222
2351: AND xd.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2352: AND xd.source_distribution_id_num_1 = rdist.line_id
2353: AND xd.ae_header_id = xh.ae_header_id
2354: AND xl.ae_header_id = xh.ae_header_id
2355: AND xl.ledger_id = p_ledger_id

Line 4460: ,ar_distributions_all rdist

4456: ,xla_distribution_links xd
4457: ,xla_events xe
4458: ,xla_event_types_vl xvl
4459: -- AR Tables
4460: ,ar_distributions_all rdist
4461: ,ar_adjustments_all radj
4462: -- OLM Tables
4463: ,okl_txl_adjsts_lns_all_b ajl
4464: ,okl_trx_ar_adjsts_all_b adj

Line 4503: AND xd.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

4499: AND xe.application_id = xvl.application_id
4500: AND xvl.event_type_code = xe.event_type_code
4501: -- XLA to AR Predicates
4502: AND xd.event_id = radj.event_id
4503: AND xd.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
4504: AND xd.source_distribution_id_num_1 = rdist.line_id
4505: -- AR Predicates
4506: AND rdist.source_type = 'ADJ' -- Assumption
4507: AND radj.adjustment_id = rdist.source_id