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 233: , (SELECT po_lookup_codes.displayed_field

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'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field

Line 234: FROM po_lookup_codes

230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes

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

231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND

Line 236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)

232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)

Line 237: , (SELECT po_lookup_codes.displayed_field

233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field

Line 238: FROM po_lookup_codes

234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes

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

235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes
243: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND

Line 240: po_lookup_codes.lookup_code = h.fob_lookup_code)

236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)
237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes
243: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
244: po_lookup_codes.lookup_code = h.shipping_control)

Line 241: , (SELECT po_lookup_codes.displayed_field

237: , (SELECT po_lookup_codes.displayed_field
238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes
243: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
244: po_lookup_codes.lookup_code = h.shipping_control)
245: , (SELECT org_freight_tl.freight_code_tl

Line 242: FROM po_lookup_codes

238: FROM po_lookup_codes
239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes
243: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
244: po_lookup_codes.lookup_code = h.shipping_control)
245: , (SELECT org_freight_tl.freight_code_tl
246: FROM org_freight_tl

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

239: WHERE po_lookup_codes.lookup_type = 'FOB' AND
240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes
243: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
244: po_lookup_codes.lookup_code = h.shipping_control)
245: , (SELECT org_freight_tl.freight_code_tl
246: FROM org_freight_tl
247: WHERE org_freight_tl.freight_code = h.ship_via_lookup_code AND

Line 244: po_lookup_codes.lookup_code = h.shipping_control)

240: po_lookup_codes.lookup_code = h.fob_lookup_code)
241: , (SELECT po_lookup_codes.displayed_field
242: FROM po_lookup_codes
243: WHERE po_lookup_codes.lookup_type = 'SHIPPING CONTROL' AND
244: po_lookup_codes.lookup_code = h.shipping_control)
245: , (SELECT org_freight_tl.freight_code_tl
246: FROM org_freight_tl
247: WHERE org_freight_tl.freight_code = h.ship_via_lookup_code AND
248: org_freight_tl.LANGUAGE = userenv('LANG') AND