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
374: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669
375: AND pol.po_line_id(+) = rti.po_line_id
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
456: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669
457: AND pol.po_line_id(+) = rti.po_line_id
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
557: FROM rcv_transactions_interface
558: WHERE interface_transaction_id =
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
711: , wip_entities we -- Added for Bug#4516067
712: , wip_discrete_jobs wdj -- Added for Bug#4516067
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
897: , wip_entities we
898: , wip_discrete_jobs wdj
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
1068: , wip_entities we
1069: , wip_discrete_jobs wdj