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_SP_ASSIGN_BY_LEASE dependencies on FND_LOOKUPS

Line 319: fnd_lookups fl,

315: loc.last_update_login LAST_UPDATE_LOGIN,
316: loc.creation_date CREATION_DATE,
317: loc.created_by CREATED_BY
318: FROM pn_locations_all loc,
319: fnd_lookups fl,
320: fnd_lookups fl1
321: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
322: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
323: AND fl1.lookup_code(+)= loc.location_type_lookup_code

Line 320: fnd_lookups fl1

316: loc.creation_date CREATION_DATE,
317: loc.created_by CREATED_BY
318: FROM pn_locations_all loc,
319: fnd_lookups fl,
320: fnd_lookups fl1
321: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
322: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
323: AND fl1.lookup_code(+)= loc.location_type_lookup_code
324: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'

Line 693: fnd_lookups fl,

689: loc.last_update_login LAST_UPDATE_LOGIN,
690: loc.creation_date CREATION_DATE,
691: loc.created_by CREATED_BY
692: FROM pn_locations_all loc,
693: fnd_lookups fl,
694: fnd_lookups fl1
695: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
696: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
697: AND fl1.lookup_code(+)= loc.location_type_lookup_code

Line 694: fnd_lookups fl1

690: loc.creation_date CREATION_DATE,
691: loc.created_by CREATED_BY
692: FROM pn_locations_all loc,
693: fnd_lookups fl,
694: fnd_lookups fl1
695: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
696: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
697: AND fl1.lookup_code(+)= loc.location_type_lookup_code
698: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'