APPS.JMF_SHIKYU_RPT_SPR_PVT dependencies on ORG_FREIGHT_TL

Line 245: , (SELECT org_freight_tl.freight_code_tl

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

Line 246: FROM org_freight_tl

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

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

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
249: org_freight_tl.organization_id = l.org_id)
250: , pvc.first_name || ' ' || pvc.last_name
251: , pvc.phone

Line 248: org_freight_tl.LANGUAGE = userenv('LANG') 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
249: org_freight_tl.organization_id = l.org_id)
250: , pvc.first_name || ' ' || pvc.last_name
251: , pvc.phone
252: , decode((SELECT COUNT(d.po_distribution_id)

Line 249: org_freight_tl.organization_id = l.org_id)

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
249: org_freight_tl.organization_id = l.org_id)
250: , pvc.first_name || ' ' || pvc.last_name
251: , pvc.phone
252: , decode((SELECT COUNT(d.po_distribution_id)
253: FROM po_distributions_all d