APPS.ARP_CONSINV dependencies on RA_CUSTOMER_TRX_LINES

Line 608: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;

604: C_detail_option hz_customer_profiles.cons_inv_type%TYPE;
605:
606: -- bug3039537
607: -- Calculate all tax amount and inclusive tax amount
608: TYPE tab_line_id IS TABLE OF ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE;
609: TYPE tab_num IS TABLE OF NUMBER ;
610:
611: l_line_id tab_line_id ;
612: l_tax_sum tab_num ;

Line 622: FROM ra_customer_trx_lines CTL

618: IS
619: SELECT link_to_cust_trx_line_id,
620: sum(nvl(CTL.extended_amount,0)),
621: sum(decode(amount_includes_tax_flag, 'Y', nvl(CTL.extended_amount,0),0))
622: FROM ra_customer_trx_lines CTL
623: WHERE CTL.customer_trx_id = l_trx_id
624: AND CTL.line_type = 'TAX'
625: GROUP BY link_to_cust_trx_line_id;
626: -- bug3039537

Line 1020: ra_customer_trx_lines

1016: nvl (gross_extended_amount, extended_amount),
1017: 0,
1018: org_id
1019: FROM
1020: ra_customer_trx_lines
1021: WHERE
1022: customer_trx_id = L_inv_trx.trx_id
1023: AND line_type NOT IN ('TAX', 'FREIGHT');
1024:

Line 1054: ra_customer_trx_lines

1050: nvl (gross_extended_amount, extended_amount),
1051: 0,
1052: org_id
1053: FROM
1054: ra_customer_trx_lines
1055: WHERE
1056: customer_trx_id = L_inv_trx.trx_id
1057: AND line_type NOT IN ('TAX', 'FREIGHT');
1058: END IF;

Line 1065: FROM ra_customer_trx_lines CTL

1061: /* bug3039537 : Removed
1062: UPDATE ar_cons_inv_trx_lines TL
1063: set TL.tax_amount =
1064: (SELECT sum(nvl(CTL.extended_amount,0))
1065: FROM ra_customer_trx_lines CTL
1066: WHERE CTL.link_to_cust_trx_line_id =
1067: TL.customer_trx_line_id
1068: AND CTL.line_type = 'TAX')
1069: WHERE

Line 1123: ra_customer_trx_lines

1119: sum (nvl (gross_extended_amount, extended_amount)),
1120: 0,
1121: org_id
1122: FROM
1123: ra_customer_trx_lines
1124: WHERE
1125: customer_trx_id = L_inv_trx.trx_id
1126: AND line_type = 'FREIGHT'
1127: GROUP BY line_type,org_id;