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_LOOKUP_CODES

Line 246: , (SELECT po_lookup_codes.displayed_field

242: , (SELECT ap_terms_tl.NAME
243: FROM ap_terms_tl
244: WHERE ap_terms_tl.term_id = h.terms_id AND
245: ap_terms_tl.LANGUAGE = userenv('LANG'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field

Line 247: FROM po_lookup_codes

243: FROM ap_terms_tl
244: WHERE ap_terms_tl.term_id = h.terms_id AND
245: ap_terms_tl.LANGUAGE = userenv('LANG'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes

Line 248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND

244: WHERE ap_terms_tl.term_id = h.terms_id AND
245: ap_terms_tl.LANGUAGE = userenv('LANG'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND

Line 249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)

245: ap_terms_tl.LANGUAGE = userenv('LANG'))
246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)

Line 250: , (SELECT po_lookup_codes.displayed_field

246: , (SELECT po_lookup_codes.displayed_field
247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field

Line 251: FROM po_lookup_codes

247: FROM po_lookup_codes
248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes

Line 252: WHERE po_lookup_codes.lookup_type = 'FOB' AND

248: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes
256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND

Line 253: po_lookup_codes.lookup_code = h.fob_lookup_code)

249: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes
256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
257: po_lookup_codes.lookup_code = h.shipping_control)

Line 254: , (SELECT po_lookup_codes.displayed_field

250: , (SELECT po_lookup_codes.displayed_field
251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes
256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
257: po_lookup_codes.lookup_code = h.shipping_control)
258: , (SELECT org_freight_tl.freight_code_tl

Line 255: FROM po_lookup_codes

251: FROM po_lookup_codes
252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes
256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
257: po_lookup_codes.lookup_code = h.shipping_control)
258: , (SELECT org_freight_tl.freight_code_tl
259: FROM org_freight_tl

Line 256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND

252: WHERE po_lookup_codes.lookup_type = 'FOB' AND
253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes
256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
257: po_lookup_codes.lookup_code = h.shipping_control)
258: , (SELECT org_freight_tl.freight_code_tl
259: FROM org_freight_tl
260: WHERE org_freight_tl.freight_code = h.ship_via_lookup_code AND

Line 257: po_lookup_codes.lookup_code = h.shipping_control)

253: po_lookup_codes.lookup_code = h.fob_lookup_code)
254: , (SELECT po_lookup_codes.displayed_field
255: FROM po_lookup_codes
256: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
257: po_lookup_codes.lookup_code = h.shipping_control)
258: , (SELECT org_freight_tl.freight_code_tl
259: FROM org_freight_tl
260: WHERE org_freight_tl.freight_code = h.ship_via_lookup_code AND
261: org_freight_tl.LANGUAGE = userenv('LANG') AND