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 ORG_FREIGHT_TL

Line 258: , (SELECT org_freight_tl.freight_code_tl

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
262: org_freight_tl.organization_id = l.org_id)

Line 259: FROM org_freight_tl

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
262: org_freight_tl.organization_id = l.org_id)
263: , pvc.first_name || ' ' || pvc.last_name

Line 260: WHERE org_freight_tl.freight_code = h.ship_via_lookup_code AND

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
262: org_freight_tl.organization_id = l.org_id)
263: , pvc.first_name || ' ' || pvc.last_name
264: , pvc.phone

Line 261: org_freight_tl.LANGUAGE = userenv('LANG') 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
262: org_freight_tl.organization_id = l.org_id)
263: , pvc.first_name || ' ' || pvc.last_name
264: , pvc.phone
265: , decode((SELECT COUNT(d.po_distribution_id)

Line 262: org_freight_tl.organization_id = l.org_id)

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
262: org_freight_tl.organization_id = l.org_id)
263: , pvc.first_name || ' ' || pvc.last_name
264: , pvc.phone
265: , decode((SELECT COUNT(d.po_distribution_id)
266: FROM po_distributions_all d