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_OPEX_TERMS_PKG dependencies on PN_TENANCIES_ALL

Line 55: pn_tenancies_all ten

51: IS
52: SELECT agr.* , loc.location_id
53: FROM pn_opex_agreements_all agr,
54: pn_locations_all loc,
55: pn_tenancies_all ten
56: WHERE agreement_id = agr_id
57: AND agr.tenancy_id = ten.tenancy_id
58: AND ten.location_id = loc.location_id;
59:

Line 655: pn_tenancies_all ten

651: IS
652: SELECT agr.* , loc.location_id
653: FROM pn_opex_agreements_all agr,
654: pn_locations_all loc,
655: pn_tenancies_all ten
656: WHERE agreement_id = agr_id
657: AND agr.tenancy_id = ten.tenancy_id
658: AND ten.location_id = loc.location_id;
659:

Line 2180: pn_tenancies_all ten

2176: pn_opex_agreements_all popex,
2177: pn_payment_terms_all ppt,
2178: pn_properties_all prop,
2179: pn_locations_all loc,
2180: pn_tenancies_all ten
2181: WHERE pl.lease_id = popex.lease_id
2182: AND popex.agreement_id = ppt.opex_agr_id
2183: AND popex.tenancy_id = ten.tenancy_id
2184: AND ten.location_id = loc.location_id