365: , po_line_locations_all pll
366: , po_vendors pov
367: , hr_locations_all hrl1
368: , hr_locations_all hrl2
369: , po_vendor_sites_all pvs
370: , per_people_f ppf
371: , rcv_routing_headers rrh
372: , wip_osp_jobs_val_v wojv
373: WHERE wlc.parent_lpn_id(+) = rti.lpn_id
447: , po_line_locations_all pll
448: , po_vendors pov
449: , hr_locations_all hrl1
450: , hr_locations_all hrl2
451: , po_vendor_sites_all pvs
452: , per_people_f ppf
453: , rcv_routing_headers rrh
454: , wip_osp_jobs_val_v wojv
455: WHERE wlc.parent_lpn_id(+) = rti.transfer_lpn_id
547: , po_line_locations_all pll
548: , po_vendors pov
549: , hr_locations hrl1
550: , hr_locations hrl2
551: -- MOAC changed po_vendor_sites to po_vendor_sites_all
552: , po_vendor_sites_all pvs
553: , hr_employees hre
554: , rcv_routing_headers rrh
555: , wip_osp_jobs_val_v wojv
548: , po_vendors pov
549: , hr_locations hrl1
550: , hr_locations hrl2
551: -- MOAC changed po_vendor_sites to po_vendor_sites_all
552: , po_vendor_sites_all pvs
553: , hr_employees hre
554: , rcv_routing_headers rrh
555: , wip_osp_jobs_val_v wojv
556: WHERE rti.GROUP_ID IN (SELECT GROUP_ID
702: , po_line_locations_all pll
703: , po_vendors pov
704: , hr_locations_all hrl1
705: , hr_locations_all hrl2
706: , po_vendor_sites_all pvs
707: , per_people_f ppf
708: , rcv_routing_headers rrh
709: -- Bug 4516067, to improve performance, query the base table directly
710: --, wip_osp_jobs_val_v wojv
888: , po_line_locations pll
889: , po_vendors pov
890: , hr_locations_all hrl1
891: , hr_locations_all hrl2
892: , po_vendor_sites_all pvs
893: , per_people_f ppf
894: , rcv_routing_headers rrh
895: -- Bug 4516067, to improve performance, query the base table directly
896: --, wip_osp_jobs_val_v wojv
1059: , po_line_locations pll
1060: , po_vendors pov
1061: , hr_locations_all hrl1
1062: , hr_locations_all hrl2
1063: , po_vendor_sites_all pvs
1064: , per_people_f ppf
1065: , rcv_routing_headers rrh
1066: -- Bug 4516067, to improve performance, query the base table directly
1067: --, wip_osp_jobs_val_v wojv