APPS.ARP_CONSINV dependencies on AR_CONS_INV_TRX_LINES

Line 341: DELETE FROM ar_cons_inv_trx_lines

337: AND currency_code = l_currency_code(i)
338: AND cut_off_date <= l_cut_off_date(i) ;
339: -- bug2778646 end
340:
341: DELETE FROM ar_cons_inv_trx_lines
342: WHERE cons_inv_id IN
343: (SELECT CI.cons_inv_id
344: FROM ar_cons_inv CI
345: WHERE CI.cons_inv_id = nvl(P_consinv_id, CI.cons_inv_id)

Line 992: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

988:
989: /* Bug 586099: For credit memo, quantity is stored in
990: quantity_credited rather than quantity_invoiced. */
991: IF (L_inv_trx.class = 'CM') THEN
992: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
993: cons_inv_line_number,
994: customer_trx_id,
995: customer_trx_line_id,
996: line_number,

Line 1026: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

1022: customer_trx_id = L_inv_trx.trx_id
1023: AND line_type NOT IN ('TAX', 'FREIGHT');
1024:
1025: ELSE
1026: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1027: cons_inv_line_number,
1028: customer_trx_id,
1029: customer_trx_line_id,
1030: line_number,

Line 1062: UPDATE ar_cons_inv_trx_lines TL

1058: END IF;
1059:
1060: /** now update lines with associated tax line **/
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 =

Line 1083: UPDATE ar_cons_inv_trx_lines

1079:
1080: -- 1. Update tax_amount
1081: -- 2. Exclude inclusive tax amount total from extended_amount
1082: FORALL i IN 1..l_line_id.count
1083: UPDATE ar_cons_inv_trx_lines
1084: SET tax_amount = l_tax_sum(i),
1085: extended_amount = extended_amount - l_include_tax_sum(i)
1086: WHERE customer_trx_id = L_inv_trx.trx_id /*4413567*/
1087: AND

Line 1095: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,

1091: END LOOP;
1092: CLOSE c_tax;
1093:
1094: /** now create 1 summary row for freight **/
1095: INSERT INTO ar_cons_inv_trx_lines (cons_inv_id,
1096: cons_inv_line_number,
1097: customer_trx_id,
1098: customer_trx_line_id,
1099: line_number,