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 197: FROM po_vendor_sites povs,

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

Line 211: FROM po_vendor_sites povs,

207: SELECT povs.vendor_site_id,
208: substr(pov.vendor_name,1,240)
209: INTO s_vendor_site_id,
210: x_vendor_name
211: FROM po_vendor_sites povs,
212: po_vendors pov
213: WHERE povs.global_attribute9 = e_transf_inscription_type
214: AND povs.global_attribute10 = '0'||substr(e_transf_inscription_number,1,8)
215: AND povs.global_attribute11 = substr(e_transf_inscription_number,9,4)