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

Line 333: fnd_lookups fl,

329: loc.last_update_login last_update_login,
330: loc.creation_date creation_date,
331: loc.created_by created_by
332: FROM pn_locations_all loc,
333: fnd_lookups fl,
334: fnd_lookups fl1
335: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
336: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
337: AND fl1.lookup_code(+)= loc.location_type_lookup_code

Line 334: fnd_lookups fl1

330: loc.creation_date creation_date,
331: loc.created_by created_by
332: FROM pn_locations_all loc,
333: fnd_lookups fl,
334: fnd_lookups fl1
335: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
336: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
337: AND fl1.lookup_code(+)= loc.location_type_lookup_code
338: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'

Line 666: fnd_lookups fl,

662: loc.last_update_login last_update_login,
663: loc.creation_date creation_date,
664: loc.created_by created_by
665: FROM pn_locations_all loc,
666: fnd_lookups fl,
667: fnd_lookups fl1
668: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
669: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
670: AND fl1.lookup_code(+)= loc.location_type_lookup_code

Line 667: fnd_lookups fl1

663: loc.creation_date creation_date,
664: loc.created_by created_by
665: FROM pn_locations_all loc,
666: fnd_lookups fl,
667: fnd_lookups fl1
668: WHERE fl.lookup_code(+) = loc.space_type_lookup_code
669: AND fl.lookup_type(+) = 'PN_SPACE_TYPE'
670: AND fl1.lookup_code(+)= loc.location_type_lookup_code
671: AND fl1.lookup_type(+)= 'PN_LOCATION_TYPE'