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 PN_DISTRIBUTIONS_ALL

Line 9: FROM pn_distributions_all

5: CURSOR get_dist(p_term_id NUMBER) IS
6: SELECT account_id,
7: account_class,
8: percentage
9: FROM pn_distributions_all
10: WHERE payment_term_id = p_term_id;
11:
12: CURSOR get_desc (p_lookup_code varchar2) is
13: SELECT meaning

Line 66: FROM pn_distributions_all

62: WHERE vat_tax_id = p_tax_code_id;
63:
64: CURSOR acnt_cls_cur(p_term_id NUMBER) IS
65: SELECT account_class
66: FROM pn_distributions_all
67: WHERE payment_term_id = p_term_id;
68:
69: CURSOR gl_segment_check IS
70: SELECT 'Y'

Line 249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,

245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
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''