DBA Data[Home] [Help]

APPS.ARP_TRX_COMPLETE_CHK dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 779: ra_cust_trx_line_salesreps s

775: SELECT l.line_number line_number,
776: l.customer_trx_line_id customer_trx_line_id,
777: round(SUM(s.revenue_percent_split),4) error_amount
778: FROM ra_customer_trx_lines l,
779: ra_cust_trx_line_salesreps s
780: WHERE pg_salesrep_required_flag = 'Y'
781: AND l.customer_trx_id = p_customer_trx_id
782: AND l.customer_trx_line_id = s.customer_trx_line_id(+)
783: AND l.line_type = 'LINE'

Line 792: ra_cust_trx_line_salesreps s

788: SELECT l.line_number line_number,
789: l.customer_trx_line_id customer_trx_line_id,
790: round(SUM(s.revenue_percent_split),4) error_amount
791: FROM ra_customer_trx_lines l,
792: ra_cust_trx_line_salesreps s
793: WHERE pg_salesrep_required_flag = 'N'
794: AND l.customer_trx_id = p_customer_trx_id
795: AND l.customer_trx_line_id = s.customer_trx_line_id
796: AND l.line_type = 'LINE'