APPS.IBY_AR_UTILS dependencies on AR_INVOICE_LINES_V

Line 143: FROM ar_invoice_lines_v

139: CURSOR c_header_freight
140: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
141: IS
142: SELECT extended_amount
143: FROM ar_invoice_lines_v
144: WHERE (link_to_cust_trx_line_id IS NULL)
145: AND (line_type = 'FREIGHT')
146: AND (customer_trx_id = ci_cust_trx_id);
147:

Line 152: FROM ar_invoice_lines_v

148: CURSOR c_freight_total
149: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
150: IS
151: SELECT SUM(extended_amount)
152: FROM ar_invoice_lines_v
153: WHERE
154: (line_type = 'FREIGHT')
155: AND (customer_trx_id = ci_cust_trx_id);
156:

Line 201: FROM ar_invoice_lines_v

197: CURSOR c_line_items
198: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
199: IS
200: SELECT customer_trx_line_id
201: FROM ar_invoice_lines_v
202: WHERE
203: ( line_type = 'LINE')
204: AND (customer_trx_id = ci_cust_trx_id);
205:

Line 227: FROM ar_invoice_lines_v

223: CURSOR c_line_items
224: (ci_cust_trx_id ar_invoice_header_v.customer_trx_id%TYPE)
225: IS
226: SELECT extended_amount
227: FROM ar_invoice_lines_v
228: WHERE
229: ( line_type = 'LINE')
230: AND (customer_trx_id = ci_cust_trx_id);
231: BEGIN

Line 242: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,

238: END get_order_amount;
239:
240: FUNCTION get_line_tax_amount
241: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
242: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
243: p_tax_type IN VARCHAR2)
244: RETURN NUMBER
245: IS
246:

Line 251: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,

247: l_sales_tax_total NUMBER := 0;
248: l_vat_tax_total NUMBER := 0;
249:
250: CURSOR c_tax_items
251: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
252: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
253: IS
254: SELECT extended_amount, location_rate_id, location_segment_id
255: FROM ar_invoice_lines_v

Line 252: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)

248: l_vat_tax_total NUMBER := 0;
249:
250: CURSOR c_tax_items
251: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
252: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
253: IS
254: SELECT extended_amount, location_rate_id, location_segment_id
255: FROM ar_invoice_lines_v
256: WHERE

Line 255: FROM ar_invoice_lines_v

251: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
252: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
253: IS
254: SELECT extended_amount, location_rate_id, location_segment_id
255: FROM ar_invoice_lines_v
256: WHERE
257: (line_type='TAX')
258: AND (customer_trx_id = ci_cust_trx_id)
259: AND (link_to_cust_trx_line_id = ci_cust_trx_line_id);

Line 285: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,

281: END get_line_tax_amount;
282:
283: FUNCTION get_line_tax_rate
284: (p_customer_trx_id IN ar_invoice_header_v.customer_trx_id%TYPE,
285: p_customer_trx_line_id IN ar_invoice_lines_v.customer_trx_line_id%TYPE,
286: p_tax_type IN VARCHAR2)
287: RETURN NUMBER
288: IS
289: l_sales_rate_total NUMBER := 0;

Line 296: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,

292: l_sales_count NUMBER := 0;
293: l_vat_count NUMBER := 0;
294:
295: CURSOR c_tax_items
296: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
297: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
298: IS
299: SELECT location_rate_id, location_segment_id, tax_rate
300: FROM ar_invoice_lines_v

Line 297: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)

293: l_vat_count NUMBER := 0;
294:
295: CURSOR c_tax_items
296: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
297: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
298: IS
299: SELECT location_rate_id, location_segment_id, tax_rate
300: FROM ar_invoice_lines_v
301: WHERE

Line 300: FROM ar_invoice_lines_v

296: (ci_cust_trx_id ar_invoice_lines_v.customer_trx_id%TYPE,
297: ci_cust_trx_line_id ar_invoice_lines_v.link_to_cust_trx_line_id%TYPE)
298: IS
299: SELECT location_rate_id, location_segment_id, tax_rate
300: FROM ar_invoice_lines_v
301: WHERE
302: (line_type='TAX')
303: AND (customer_trx_id = ci_cust_trx_id)
304: AND (link_to_cust_trx_line_id = ci_cust_trx_line_id);