APPS.IBY_AR_UTILS dependencies on AR_INVOICE_LINES_V

Line 520: FROM ar_invoice_lines_v

516: CURSOR c_header_freight
517: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
518: IS
519: SELECT extended_amount
520: FROM ar_invoice_lines_v
521: WHERE (link_to_cust_trx_line_id IS NULL)
522: AND (line_type = 'FREIGHT')
523: AND (customer_trx_id = ci_cust_trx_id);
524:

Line 529: FROM ar_invoice_lines_v

525: CURSOR c_freight_total
526: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
527: IS
528: SELECT SUM(extended_amount)
529: FROM ar_invoice_lines_v
530: WHERE
531: (line_type = 'FREIGHT')
532: AND (customer_trx_id = ci_cust_trx_id);
533:

Line 578: FROM ar_invoice_lines_v

574: CURSOR c_line_items
575: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
576: IS
577: SELECT customer_trx_line_id
578: FROM ar_invoice_lines_v
579: WHERE
580: ( line_type = 'LINE')
581: AND (customer_trx_id = ci_cust_trx_id);
582:

Line 604: FROM ar_invoice_lines_v

600: CURSOR c_line_items
601: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
602: IS
603: SELECT extended_amount
604: FROM ar_invoice_lines_v
605: WHERE
606: ( line_type = 'LINE')
607: AND (customer_trx_id = ci_cust_trx_id);
608: BEGIN

Line 619: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,

615: END get_order_amount;
616:
617: FUNCTION get_line_tax_amount
618: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
619: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
620: p_tax_type IN VARCHAR2)
621: RETURN NUMBER
622: IS
623:

Line 628: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,

624: l_sales_tax_total NUMBER := 0;
625: l_vat_tax_total NUMBER := 0;
626:
627: CURSOR c_tax_items
628: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
629: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
630: IS
631: SELECT extended_amount, location_rate_id, location_segment_id
632: FROM ar_invoice_lines_v

Line 629: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)

625: l_vat_tax_total NUMBER := 0;
626:
627: CURSOR c_tax_items
628: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
629: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
630: IS
631: SELECT extended_amount, location_rate_id, location_segment_id
632: FROM ar_invoice_lines_v
633: WHERE

Line 632: FROM ar_invoice_lines_v

628: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
629: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
630: IS
631: SELECT extended_amount, location_rate_id, location_segment_id
632: FROM ar_invoice_lines_v
633: WHERE
634: (line_type='TAX')
635: AND (customer_trx_id = ci_cust_trx_id)
636: AND (link_to_cust_trx_line_id = ci_cust_trx_line_id);

Line 662: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,

658: END get_line_tax_amount;
659:
660: FUNCTION get_line_tax_rate
661: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
662: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
663: p_tax_type IN VARCHAR2)
664: RETURN NUMBER
665: IS
666: l_sales_rate_total NUMBER := 0;

Line 673: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,

669: l_sales_count NUMBER := 0;
670: l_vat_count NUMBER := 0;
671:
672: CURSOR c_tax_items
673: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
674: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
675: IS
676: SELECT location_rate_id, location_segment_id, tax_rate
677: FROM ar_invoice_lines_v

Line 674: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)

670: l_vat_count NUMBER := 0;
671:
672: CURSOR c_tax_items
673: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
674: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
675: IS
676: SELECT location_rate_id, location_segment_id, tax_rate
677: FROM ar_invoice_lines_v
678: WHERE

Line 677: FROM ar_invoice_lines_v

673: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
674: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
675: IS
676: SELECT location_rate_id, location_segment_id, tax_rate
677: FROM ar_invoice_lines_v
678: WHERE
679: (line_type='TAX')
680: AND (customer_trx_id = ci_cust_trx_id)
681: AND (link_to_cust_trx_line_id = ci_cust_trx_line_id);