APPS.FV_SLA_AR_PROCESSING_PKG dependencies on AR_DISTRIBUTIONS_L_V

Line 614: FROM ar_distributions_l_v d,

610: SELECT d.event_id,
611: d.line_number,
612: d.dist_code_combination_id,
613: l.trx_line_dist_ccid
614: FROM ar_distributions_l_v d,
615: ar_cust_trx_lines_l_v l
616: WHERE d.dist_source_type IN ('REC', 'ADJ')
617: AND l.event_id = d.event_id
618: AND l.line_number = d.line_number

Line 626: FROM ar_distributions_l_v d

622: SELECT d.event_id,
623: d.line_number,
624: d.dist_code_combination_id,
625: d.dist_code_combination_id trx_line_dist_ccid
626: FROM ar_distributions_l_v d
627: WHERE d.dist_source_type IN ('ACC', 'OTHER ACC')
628: AND d.event_id = c_event_id
629: AND NVL(d.dist_ref_mf_dist_flag||d.dist_source_table_secondary, ' ') <> 'UUPMFCHMIAR';
630:

Line 639: FROM ar_distributions_l_v arv

635: IS
636: SELECT arv.event_id,
637: arv.line_number,
638: arv.dist_code_combination_id
639: FROM ar_distributions_l_v arv
640: WHERE arv.event_id = c_event_id
641: AND dist_source_type = 'MISCCASH'
642: AND dist_mfar_additional_entry = 'Y'
643: AND dist_paired_source_type = 'CLEARED';