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.JL_BR_AP_VALIDATE_COLLECTION dependencies on PO_VENDOR_SITES

Line 200: FROM po_vendor_sites povs,

196: SELECT povs.vendor_site_id,
197: substr(pov.vendor_name,1,240)
198: INTO s_vendor_site_id,
199: x_vendor_name
200: FROM po_vendor_sites povs,
201: po_vendors pov
202: WHERE povs.global_attribute9 = e_transf_inscription_type
203: AND povs.global_attribute10 = substr(e_transf_inscription_number,4,9)
204: AND povs.global_attribute12 = substr(e_transf_inscription_number,13,2)

Line 217: FROM po_vendor_sites povs,

213: SELECT povs.vendor_site_id,
214: substr(pov.vendor_name,1,240)
215: INTO s_vendor_site_id,
216: x_vendor_name
217: FROM po_vendor_sites povs,
218: po_vendors pov
219: WHERE povs.global_attribute9 = e_transf_inscription_type
220: AND povs.global_attribute10 = '0'||substr(e_transf_inscription_number,1,8)
221: AND povs.global_attribute11 = substr(e_transf_inscription_number,9,4)