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.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_TERMS

Line 60: l_term_id ra_terms.term_id%TYPE := NULL;

56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;
58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
60: l_term_id ra_terms.term_id%TYPE := NULL;
61: l_salesrep_id ra_salesreps.salesrep_id%TYPE := NULL;
62: l_term_name ra_terms.name%TYPE := NULL;
63: l_salesrep_name ra_salesreps.NAME%TYPE := NULL;
64: l_interface_header_context VARCHAR2(30) := NULL;

Line 62: l_term_name ra_terms.name%TYPE := NULL;

58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
60: l_term_id ra_terms.term_id%TYPE := NULL;
61: l_salesrep_id ra_salesreps.salesrep_id%TYPE := NULL;
62: l_term_name ra_terms.name%TYPE := NULL;
63: l_salesrep_name ra_salesreps.NAME%TYPE := NULL;
64: l_interface_header_context VARCHAR2(30) := NULL;
65: l_interface_header_attribute1 VARCHAR2(150) := NULL;
66: l_interface_header_attribute2 VARCHAR2(150) := NULL;

Line 4617: l_term_name ra_terms_vl.NAME%TYPE;

4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);

Line 4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;

4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);
4622:

Line 4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;

4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);
4622:
4623: BEGIN

Line 5107: FROM ra_terms_vl rt

5103: rt.END_DATE_ACTIVE
5104: INTO l_term_name,
5105: l_term_start_date,
5106: l_term_end_Date
5107: FROM ra_terms_vl rt
5108: WHERE 1 = (SELECT Count(*)
5109: FROM ra_terms_lines rtl
5110: WHERE rtl.term_id = rt.term_id
5111: AND rtl.relative_amount = rt.base_amount

Line 5109: FROM ra_terms_lines rtl

5105: l_term_start_date,
5106: l_term_end_Date
5107: FROM ra_terms_vl rt
5108: WHERE 1 = (SELECT Count(*)
5109: FROM ra_terms_lines rtl
5110: WHERE rtl.term_id = rt.term_id
5111: AND rtl.relative_amount = rt.base_amount
5112: AND rtl.due_days = 0)
5113: AND Nvl(rt.PARTIAL_DISCOUNT_FLAG,'N') = 'N'

Line 5671: FROM ra_terms_vl rt

5667:
5668: /* Insert Payment Term Name also */
5669:
5670: SELECT rt.NAME INTO l_term_name
5671: FROM ra_terms_vl rt
5672: WHERE rt.term_id = p_in_rec.payment_term_id;
5673:
5674: BEGIN
5675: INSERT INTO ra_interface_lines_all