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_LEASES

Line 244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

240: , ''MM/DD/YYYY''))
241: ,''MM/DD/YYYY'') as rule_gl_date,
242: ps.schedule_date as schedule_date
243: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
244: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
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,

Line 297: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,

293: pt.payment_purpose_code as payment_purpose,
294: pt.payment_term_type_code as payment_type,
295: ps.schedule_date as schedule_date
296: FROM PN_PAYMENT_ITEMS pi, PN_PAYMENT_SCHEDULES_ALL ps,
297: PN_PAYMENT_TERMS_ALL pt, PN_LEASES_ALL le,
298: HZ_CUST_SITE_USES_ALL hzc, HZ_CUST_SITE_USES_ALL hzc1,
299: hz_parties party, hz_cust_accounts_ALL cust_acc,
300: fnd_lookups type_lookup, fnd_lookups purpose_lookup,
301: hr_operating_units ou

Line 653: v_pn_lease_num PN_LEASES.lease_num%TYPE;

649: v_pn_proj_attr5 PN_PAYMENT_TERMS.project_attribute5%TYPE;
650: v_pn_proj_attr6 PN_PAYMENT_TERMS.project_attribute6%TYPE;
651: v_pn_proj_attr7 PN_PAYMENT_TERMS.project_attribute7%TYPE;
652: v_pn_org_id PN_PAYMENT_TERMS.org_id%TYPE;
653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
657: v_pn_lease_id PN_LEASES.lease_id%TYPE;

Line 657: v_pn_lease_id PN_LEASES.lease_id%TYPE;

653: v_pn_lease_num PN_LEASES.lease_num%TYPE;
654: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
655: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
656: v_pn_description PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
657: v_pn_lease_id PN_LEASES.lease_id%TYPE;
658: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
659: v_normalize PN_PAYMENT_TERMS.normalize%TYPE;
660: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
661: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;

Line 1825: v_pn_lease_num PN_LEASES.lease_num%TYPE;

1821: ,p_customer_id NUMBER
1822: ,p_grp_param VARCHAR2
1823: )
1824: IS
1825: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;

Line 1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;

1822: ,p_grp_param VARCHAR2
1823: )
1824: IS
1825: v_pn_lease_num PN_LEASES.lease_num%TYPE;
1826: v_pn_lease_id PN_LEASES.lease_id%TYPE;
1827: v_pn_period_name PN_PAYMENT_SCHEDULES.period_name%TYPE;
1828: v_pn_code_combination_id PN_PAYMENT_TERMS.code_combination_id%TYPE;
1829: v_pn_cust_ship_site_id PN_PAYMENT_TERMS.cust_ship_site_id%TYPE;
1830: v_pn_tax_code_id PN_PAYMENT_TERMS.tax_code_id%TYPE;