[Home] [Help]
374: , hr_locations_all hrl1
375: , hr_locations_all hrl2
376: , po_vendor_sites_all pvs
377: , per_people_f ppf
378: , rcv_routing_headers rrh
379: , wip_osp_jobs_val_v wojv
380: WHERE wlc.parent_lpn_id(+) = rti.lpn_id
381: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669
382: AND pol.po_line_id(+) = rti.po_line_id
456: , hr_locations_all hrl1
457: , hr_locations_all hrl2
458: , po_vendor_sites_all pvs
459: , per_people_f ppf
460: , rcv_routing_headers rrh
461: , wip_osp_jobs_val_v wojv
462: WHERE wlc.parent_lpn_id(+) = rti.transfer_lpn_id
463: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669
464: AND pol.po_line_id(+) = rti.po_line_id
557: , hr_locations hrl2
558: -- MOAC changed po_vendor_sites to po_vendor_sites_all
559: , po_vendor_sites_all pvs
560: , hr_employees hre
561: , rcv_routing_headers rrh
562: , wip_osp_jobs_val_v wojv
563: WHERE rti.GROUP_ID IN (SELECT GROUP_ID
564: FROM rcv_transactions_interface
565: WHERE interface_transaction_id =
717: , hr_locations_all hrl1
718: , hr_locations_all hrl2
719: , po_vendor_sites_all pvs
720: , per_people_f ppf
721: , rcv_routing_headers rrh
722: -- Bug 4516067, to improve performance, query the base table directly
723: --, wip_osp_jobs_val_v wojv
724: , wip_entities we -- Added for Bug#4516067
725: , wip_discrete_jobs wdj -- Added for Bug#4516067
915: , hr_locations_all hrl1
916: , hr_locations_all hrl2
917: , po_vendor_sites_all pvs
918: , per_people_f ppf
919: , rcv_routing_headers rrh
920: -- Bug 4516067, to improve performance, query the base table directly
921: --, wip_osp_jobs_val_v wojv
922: , wip_entities we
923: , wip_discrete_jobs wdj
1098: , hr_locations_all hrl1
1099: , hr_locations_all hrl2
1100: , po_vendor_sites_all pvs
1101: , per_people_f ppf
1102: , rcv_routing_headers rrh
1103: -- Bug 4516067, to improve performance, query the base table directly
1104: --, wip_osp_jobs_val_v wojv
1105: , wip_entities we
1106: , wip_discrete_jobs wdj