eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_BPA_UTILS_PKG dependencies on RA_CUSTOMER_TRX

Line 19: from ra_customer_trx_lines ctl

15:
16: FUNCTION fn_get_header_level_so ( p_customer_trx_id IN number ) return varchar2 AS
17: cursor c_linesSO is
18: select distinct ctl.sales_order
19: from ra_customer_trx_lines ctl
20: where ctl.customer_trx_id = p_customer_trx_id
21: and ctl.line_type = 'LINE';
22:
23: l_count_sales_orders number := 0;

Line 48: from ra_customer_trx_lines ctl

44:
45: FUNCTION fn_get_header_level_co ( p_customer_trx_id IN number ) return varchar2 AS
46: cursor c_linesCO is
47: select distinct ctl.interface_line_attribute1
48: from ra_customer_trx_lines ctl
49: where ctl.customer_trx_id = p_customer_trx_id
50: and ctl.line_type = 'LINE';
51:
52: l_count_contract_numbers number := 0;

Line 77: from ra_customer_trx ctl

73:
74: FUNCTION fn_get_billing_line_level ( p_customer_trx_id IN number ) return varchar2 AS
75: cursor c_headerlevel is
76: select 1
77: from ra_customer_trx ctl
78: where ctl.customer_trx_id = p_customer_trx_id
79: and ctl.interface_header_context = 'OKS CONTRACTS';
80: cursor c_linelevel is
81: select ctl.INVOICED_LINE_ACCTG_LEVEL

Line 82: from ra_customer_trx_lines ctl

78: where ctl.customer_trx_id = p_customer_trx_id
79: and ctl.interface_header_context = 'OKS CONTRACTS';
80: cursor c_linelevel is
81: select ctl.INVOICED_LINE_ACCTG_LEVEL
82: from ra_customer_trx_lines ctl
83: where ctl.customer_trx_id = p_customer_trx_id
84: and ctl.line_type = 'LINE'
85: and ctl.interface_line_context = 'OKS CONTRACTS'
86: and ctl.interface_line_attribute9 = 'Service';

Line 112: from ra_customer_trx trx,

108:
109: FUNCTION fn_get_profile_class_name ( p_customer_trx_id IN number ) return varchar2 AS
110: cursor c_profileclass1 is
111: select hzc.name
112: from ra_customer_trx trx,
113: hz_customer_profiles hzp,
114: hz_cust_profile_classes hzc
115: where trx.customer_trx_id = p_customer_trx_id
116: and trx.bill_to_customer_id = hzp.cust_account_id

Line 122: from ra_customer_trx trx,

118: and hzp.profile_class_id = hzc.profile_class_id;
119:
120: cursor c_profileclass2 is
121: select hzc.name
122: from ra_customer_trx trx,
123: hz_customer_profiles hzp,
124: hz_cust_profile_classes hzc
125: where trx.customer_trx_id = p_customer_trx_id
126: and trx.bill_to_customer_id = hzp.cust_account_id

Line 202: FROM ra_customer_trx_lines

198: -- and future integration with other source products.
199: FUNCTION fn_trx_has_groups ( p_customer_trx_id IN number ) return varchar2 AS
200: CURSOR c_trx_has_groups IS
201: SELECT 1
202: FROM ra_customer_trx_lines
203: WHERE customer_trx_id = p_customer_trx_id
204: AND line_type = 'LINE'
205: and (source_data_key1 is not null
206: or source_data_key2 is not null

Line 230: from ra_customer_trx_lines ctl

226:
227: FUNCTION fn_get_line_taxrate( p_customer_trx_line_id IN number ) return varchar2 AS
228: cursor c_linetax is
229: SELECT to_char(round(ctl.tax_rate,4)) line_tax_rate
230: from ra_customer_trx_lines ctl
231: where
232: ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
233: and ctl.line_type = 'TAX'
234: and rownum = 1;

Line 254: from ra_customer_trx_lines ctl,

250:
251: FUNCTION fn_get_line_taxname( p_customer_trx_line_id IN number ) return varchar2 AS
252: cursor c_linetax is
253: SELECT v.tax_rate_name as printed_tax_name
254: from ra_customer_trx_lines ctl,
255: zx_rates_vl v
256: where
257: ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
258: and ctl.line_type = 'TAX'

Line 280: from ra_customer_trx_lines ctl,

276:
277: FUNCTION fn_get_line_taxcode( p_customer_trx_line_id IN number ) return varchar2 AS
278: cursor c_linetax is
279: SELECT v.tax_rate_code as tax_code
280: from ra_customer_trx_lines ctl,
281: zx_rates_vl v
282: where
283: ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
284: and ctl.line_type = 'TAX'

Line 306: from ra_customer_trx_lines lines

302:
303: FUNCTION fn_get_group_taxrate (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2 AS
304: cursor c_lines is
305: SELECT lines.customer_trx_line_id
306: from ra_customer_trx_lines lines
307: where
308: lines.customer_trx_id = p_customer_trx_id
309: and lines.line_type = 'LINE'
310: and source_data_key1 = id

Line 316: from ra_customer_trx_lines ctl

312: and rownum = 1;
313:
314: cursor c_linetax (id number) is
315: SELECT to_char(round(ctl.tax_rate,4)) line_tax_rate
316: from ra_customer_trx_lines ctl
317: where
318: ctl.link_to_cust_trx_line_id = id
319: and ctl.line_type = 'TAX'
320: and rownum = 1;

Line 352: from ra_customer_trx_lines lines

348:
349: FUNCTION fn_get_group_taxname (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2 AS
350: cursor c_lines is
351: SELECT lines.customer_trx_line_id
352: from ra_customer_trx_lines lines
353: where
354: lines.customer_trx_id = p_customer_trx_id
355: and lines.line_type = 'LINE'
356: and source_data_key1 = id

Line 362: from ra_customer_trx_lines ctl,

358: and rownum = 1;
359:
360: cursor c_linetax (id number) is
361: SELECT v.tax_rate_name as printed_tax_name
362: from ra_customer_trx_lines ctl,
363: zx_rates_vl v
364: where
365: ctl.link_to_cust_trx_line_id = id
366: and ctl.line_type = 'TAX'

Line 400: from ra_customer_trx_lines lines

396:
397: FUNCTION fn_get_group_taxcode (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2 AS
398: cursor c_lines is
399: SELECT lines.customer_trx_line_id
400: from ra_customer_trx_lines lines
401: where
402: lines.customer_trx_id = p_customer_trx_id
403: and lines.line_type = 'LINE'
404: and source_data_key1 = id

Line 410: from ra_customer_trx_lines ctl,

406: and rownum = 1;
407:
408: cursor c_linetax (id number) is
409: SELECT v.tax_rate_code as tax_code
410: from ra_customer_trx_lines ctl,
411: zx_rates_vl v
412: where
413: ctl.link_to_cust_trx_line_id = id
414: and ctl.line_type = 'TAX'

Line 448: from ra_customer_trx_lines lines

444:
445: FUNCTION fn_get_group_taxyn (p_customer_trx_id IN number, id in number, bcl_id in number) return varchar2 AS
446: cursor c_lines is
447: SELECT lines.customer_trx_line_id
448: from ra_customer_trx_lines lines
449: where
450: lines.customer_trx_id = p_customer_trx_id
451: and lines.line_type = 'LINE'
452: and source_data_key1 = id

Line 481: from ra_customer_trx_lines ctl

477: ctl.vat_tax_id,
478: ctl.tax_exemption_id,
479: ctl.sales_tax_id,
480: ctl.tax_precedence
481: from ra_customer_trx_lines ctl
482: where ctl.customer_trx_line_id = p_customer_trx_line_id;
483:
484: description varchar2(2000) := null;
485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;

Line 485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;

481: from ra_customer_trx_lines ctl
482: where ctl.customer_trx_line_id = p_customer_trx_line_id;
483:
484: description varchar2(2000) := null;
485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;
486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;
487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;

Line 486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;

482: where ctl.customer_trx_line_id = p_customer_trx_line_id;
483:
484: description varchar2(2000) := null;
485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;
486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;
487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;
490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;

Line 487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;

483:
484: description varchar2(2000) := null;
485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;
486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;
487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;
490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;
491: tax_precedence ra_customer_trx_lines.TAX_PRECEDENCE%TYPE;

Line 488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;

484: description varchar2(2000) := null;
485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;
486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;
487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;
490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;
491: tax_precedence ra_customer_trx_lines.TAX_PRECEDENCE%TYPE;
492:

Line 489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;

485: line_type ra_customer_trx_lines.LINE_TYPE%TYPE;
486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;
487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;
490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;
491: tax_precedence ra_customer_trx_lines.TAX_PRECEDENCE%TYPE;
492:
493: BEGIN

Line 490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;

486: line_description ra_customer_trx_lines.DESCRIPTION%TYPE;
487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;
490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;
491: tax_precedence ra_customer_trx_lines.TAX_PRECEDENCE%TYPE;
492:
493: BEGIN
494: open c_linetax;

Line 491: tax_precedence ra_customer_trx_lines.TAX_PRECEDENCE%TYPE;

487: tax_rate ra_customer_trx_lines.TAX_RATE%TYPE;
488: vat_tax_id ra_customer_trx_lines.VAT_TAX_ID%TYPE;
489: tax_exemption_id ra_customer_trx_lines.TAX_EXEMPTION_ID%TYPE;
490: location_rate_id ra_customer_trx_lines.SALES_TAX_ID%TYPE;
491: tax_precedence ra_customer_trx_lines.TAX_PRECEDENCE%TYPE;
492:
493: BEGIN
494: open c_linetax;
495: fetch c_linetax into line_type, line_description, tax_rate, vat_tax_id, tax_exemption_id, location_rate_id, tax_precedence;