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.PNRX_LEASE_OPTIONS dependencies on FND_LOOKUPS

Line 303: fnd_lookups fnd,

299: les.creation_date CREATION_DATE,
300: les.created_by CREATED_BY
301: FROM pn_leases_v les,
302: pn_tenancies ten,
303: fnd_lookups fnd,
304: fnd_lookups fl1,
305: fnd_lookups fl2,
306: pn_options opt
307: WHERE ten.lease_id = les.lease_id

Line 304: fnd_lookups fl1,

300: les.created_by CREATED_BY
301: FROM pn_leases_v les,
302: pn_tenancies ten,
303: fnd_lookups fnd,
304: fnd_lookups fl1,
305: fnd_lookups fl2,
306: pn_options opt
307: WHERE ten.lease_id = les.lease_id
308: AND ten.primary_flag ='||''''||'Y'||''''||'

Line 305: fnd_lookups fl2,

301: FROM pn_leases_v les,
302: pn_tenancies ten,
303: fnd_lookups fnd,
304: fnd_lookups fl1,
305: fnd_lookups fl2,
306: pn_options opt
307: WHERE ten.lease_id = les.lease_id
308: AND ten.primary_flag ='||''''||'Y'||''''||'
309: AND les.status = fnd.lookup_code

Line 495: fnd_lookups fnd,

491: loc.gross_area GROSS_AREA,
492: fnd.meaning TENURE
493: FROM pn_locations_all loc,
494: pn_addresses_all pa,
495: fnd_lookups fnd,
496: fnd_lookups fl1
497: WHERE pa.address_id(+) = loc.address_id
498: AND loc.lease_or_owned = fnd.lookup_code(+)
499: AND fnd.lookup_type(+) = 'PN_LEASED_OR_OWNED'

Line 496: fnd_lookups fl1

492: fnd.meaning TENURE
493: FROM pn_locations_all loc,
494: pn_addresses_all pa,
495: fnd_lookups fnd,
496: fnd_lookups fl1
497: WHERE pa.address_id(+) = loc.address_id
498: AND loc.lease_or_owned = fnd.lookup_code(+)
499: AND fnd.lookup_type(+) = 'PN_LEASED_OR_OWNED'
500: AND fl1.lookup_code(+) = loc.location_type_lookup_code

Line 542: fnd_lookups fl,

538: opt.start_date OPTION_COMM_DATE,
539: opt.expiration_date OPTION_EXP_DATE,
540: opt.option_comments OPTION_COMMENTS
541: FROM pn_options_all opt,
542: fnd_lookups fl,
543: fnd_lookups fl1
544: WHERE opt.lease_id = V_LEASE_ID
545: AND fl.lookup_code(+)= opt.option_type_code
546: AND fl.lookup_type(+)= 'PN_LEASE_OPTION_TYPE'

Line 543: fnd_lookups fl1

539: opt.expiration_date OPTION_EXP_DATE,
540: opt.option_comments OPTION_COMMENTS
541: FROM pn_options_all opt,
542: fnd_lookups fl,
543: fnd_lookups fl1
544: WHERE opt.lease_id = V_LEASE_ID
545: AND fl.lookup_code(+)= opt.option_type_code
546: AND fl.lookup_type(+)= 'PN_LEASE_OPTION_TYPE'
547: AND fl1.lookup_code(+)= opt.option_status_lookup_code