DBA Data[Home] [Help]

APPS.FV_SLA_AR_PROCESSING_PKG dependencies on AR_CUST_TRX_LINES_L_V

Line 590: FROM ar_cust_trx_lines_l_v l

586: IS
587: SELECT l.event_id,
588: l.trx_line_dist_ccid,
589: l.line_number
590: FROM ar_cust_trx_lines_l_v l
591: WHERE l.event_id = c_event_id
592: AND l.trx_line_dist_account_class = 'REV';
593:
594: CURSOR cur_ar_cm_extract_details

Line 602: FROM ar_cust_trx_lines_l_v l

598: IS
599: SELECT l.event_id,
600: l.trx_line_dist_ccid,
601: l.line_number
602: FROM ar_cust_trx_lines_l_v l
603: WHERE l.event_id = c_event_id
604: AND l.trx_line_dist_account_class = 'REV';
605:
606: CURSOR cur_ar_rct_extract_details

Line 615: ar_cust_trx_lines_l_v l

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
619: AND d.event_id = c_event_id