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.JMF_SHIKYU_RPT_SPR_PVT dependencies on PO_VENDORS

Line 223: , (SELECT po_vendors.customer_num

219: , hrloc2.region_1 || ' ' || hrloc2.region_2 || ' ' || hrloc2.postal_code
220: , ( SELECT nls_territory
221: FROM FND_TERRITORIES
222: WHERE territory_code= hrloc2.country)
223: , (SELECT po_vendors.customer_num
224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors

Line 224: FROM po_vendors

220: , ( SELECT nls_territory
221: FROM FND_TERRITORIES
222: WHERE territory_code= hrloc2.country)
223: , (SELECT po_vendors.customer_num
224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)

Line 225: WHERE po_vendors.vendor_id = h.vendor_id)

221: FROM FND_TERRITORIES
222: WHERE territory_code= hrloc2.country)
223: , (SELECT po_vendors.customer_num
224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME

Line 226: , (SELECT po_vendors.segment1

222: WHERE territory_code= hrloc2.country)
223: , (SELECT po_vendors.customer_num
224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl

Line 227: FROM po_vendors

223: , (SELECT po_vendors.customer_num
224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND

Line 228: WHERE po_vendors.vendor_id = h.vendor_id)

224: FROM po_vendors
225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))