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.PN_EXP_TO_AR dependencies on RA_RULES

Line 22: FROM ra_rules

18: CURSOR get_rule_name (p_rule_id number) is
19: SELECT name,
20: type,
21: frequency
22: FROM ra_rules
23: WHERE rule_id = p_rule_id;
24:
25: CURSOR get_receipt_name (p_receipt_method_id number) is
26: SELECT name

Line 250: RA_RULES rr

246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,
249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,
250: RA_RULES rr
251: WHERE pi.payment_term_id = pt.payment_term_id
252: AND pi.payment_schedule_id = ps.payment_schedule_id
253: AND pi.export_to_ar_flag = ''Y''
254: and ps.payment_status_lookup_code =''APPROVED''

Line 571: l_inv_rule_name RA_RULES.NAME%TYPE;

567:
568: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
569: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
570: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
574: l_acc_rule_name RA_RULES.NAME%TYPE;
575: l_acc_rule_type RA_RULES.TYPE%TYPE;

Line 572: l_inv_rule_type RA_RULES.TYPE%TYPE;

568: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
569: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
570: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
574: l_acc_rule_name RA_RULES.NAME%TYPE;
575: l_acc_rule_type RA_RULES.TYPE%TYPE;
576: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;

Line 573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;

569: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
570: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
574: l_acc_rule_name RA_RULES.NAME%TYPE;
575: l_acc_rule_type RA_RULES.TYPE%TYPE;
576: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
577: l_desc RA_INTERFACE_LINES.description%TYPE;

Line 574: l_acc_rule_name RA_RULES.NAME%TYPE;

570: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
574: l_acc_rule_name RA_RULES.NAME%TYPE;
575: l_acc_rule_type RA_RULES.TYPE%TYPE;
576: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
577: l_desc RA_INTERFACE_LINES.description%TYPE;
578: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;

Line 575: l_acc_rule_type RA_RULES.TYPE%TYPE;

571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
574: l_acc_rule_name RA_RULES.NAME%TYPE;
575: l_acc_rule_type RA_RULES.TYPE%TYPE;
576: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
577: l_desc RA_INTERFACE_LINES.description%TYPE;
578: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
579: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;

Line 576: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;

572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
574: l_acc_rule_name RA_RULES.NAME%TYPE;
575: l_acc_rule_type RA_RULES.TYPE%TYPE;
576: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
577: l_desc RA_INTERFACE_LINES.description%TYPE;
578: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
579: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;
580: l_cust_trx_name RA_CUST_TRX_TYPES.NAME%TYPE;

Line 1911: l_inv_rule_name RA_RULES.name%TYPE;

1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;
1914: l_acc_rule_name RA_RULES.name%TYPE;
1915: l_acc_rule_type RA_RULES.type%TYPE;

Line 1912: l_inv_rule_type RA_RULES.type%TYPE;

1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;
1914: l_acc_rule_name RA_RULES.name%TYPE;
1915: l_acc_rule_type RA_RULES.type%TYPE;
1916: l_acc_rule_freq RA_RULES.frequency%TYPE;

Line 1913: l_inv_rule_freq RA_RULES.frequency%TYPE;

1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;
1914: l_acc_rule_name RA_RULES.name%TYPE;
1915: l_acc_rule_type RA_RULES.type%TYPE;
1916: l_acc_rule_freq RA_RULES.frequency%TYPE;
1917: l_desc RA_INTERFACE_LINES.description%TYPE;

Line 1914: l_acc_rule_name RA_RULES.name%TYPE;

1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;
1914: l_acc_rule_name RA_RULES.name%TYPE;
1915: l_acc_rule_type RA_RULES.type%TYPE;
1916: l_acc_rule_freq RA_RULES.frequency%TYPE;
1917: l_desc RA_INTERFACE_LINES.description%TYPE;
1918: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;

Line 1915: l_acc_rule_type RA_RULES.type%TYPE;

1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;
1914: l_acc_rule_name RA_RULES.name%TYPE;
1915: l_acc_rule_type RA_RULES.type%TYPE;
1916: l_acc_rule_freq RA_RULES.frequency%TYPE;
1917: l_desc RA_INTERFACE_LINES.description%TYPE;
1918: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1919: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;

Line 1916: l_acc_rule_freq RA_RULES.frequency%TYPE;

1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;
1914: l_acc_rule_name RA_RULES.name%TYPE;
1915: l_acc_rule_type RA_RULES.type%TYPE;
1916: l_acc_rule_freq RA_RULES.frequency%TYPE;
1917: l_desc RA_INTERFACE_LINES.description%TYPE;
1918: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1919: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1920: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;