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_LOCATIONS_ALL

Line 54: pn_locations_all loc,

50: CURSOR agreement_cur(agr_id IN NUMBER)
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;

Line 654: pn_locations_all loc,

650: CURSOR agreement_cur(agr_id IN NUMBER)
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;

Line 1592: FROM pn_locations_all loc

1588: IS
1589:
1590: CURSOR csr_prop_id(loc_id IN NUMBER) IS
1591: SELECT loc.property_id prop_id
1592: FROM pn_locations_all loc
1593: WHERE loc.parent_location_id IS NULL
1594: START WITH loc.location_id = loc_id
1595: CONNECT BY PRIOR loc.parent_location_id=loc.location_id;
1596:

Line 2179: pn_locations_all loc,

2175: FROM pn_leases_all pl,
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