370: , po_headers_trx_v pha -- CLM project, bug 9403291
371: , rcv_shipment_headers rsh
372: , po_line_locations_trx_v pll -- CLM project, bug 9403291
373: , po_vendors pov
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
371: , rcv_shipment_headers rsh
372: , po_line_locations_trx_v pll -- CLM project, bug 9403291
373: , po_vendors pov
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
452: , po_headers_trx_v pha -- CLM projet, bug 9403291
453: , rcv_shipment_headers rsh
454: , po_line_locations_trx_v pll -- CLM project, bug 9403291
455: , po_vendors pov
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
453: , rcv_shipment_headers rsh
454: , po_line_locations_trx_v pll -- CLM project, bug 9403291
455: , po_vendors pov
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
552: , po_headers_trx_v pha -- CLM project, bug 9403291
553: , rcv_shipment_headers rsh
554: , po_line_locations_trx_v pll -- CLM project, bug 9403291
555: , po_vendors pov
556: , hr_locations hrl1
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
553: , rcv_shipment_headers rsh
554: , po_line_locations_trx_v pll -- CLM project, bug 9403291
555: , po_vendors pov
556: , hr_locations hrl1
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
713: , po_headers_trx_v pha -- CLM project, bug 9403291
714: , rcv_shipment_headers rsh
715: , po_line_locations_trx_v pll -- CLM project, bug 9403291
716: , po_vendors pov
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
714: , rcv_shipment_headers rsh
715: , po_line_locations_trx_v pll -- CLM project, bug 9403291
716: , po_vendors pov
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
911: , po_headers_trx_v pha -- CLM project, bug 9403291
912: , rcv_shipment_headers rsh
913: , po_line_locations_trx_v pll -- CLM project, bug 9403291
914: , po_vendors pov
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
912: , rcv_shipment_headers rsh
913: , po_line_locations_trx_v pll -- CLM project, bug 9403291
914: , po_vendors pov
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
1094: , po_headers_trx_v pha -- CLM project, bug 9403291
1095: , rcv_shipment_headers rsh
1096: , po_line_locations_trx_v pll -- CLM project, bug 9403291
1097: , po_vendors pov
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
1095: , rcv_shipment_headers rsh
1096: , po_line_locations_trx_v pll -- CLM project, bug 9403291
1097: , po_vendors pov
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
2104: -- Increased this variable size to the corresponding column size in the table.
2105: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
2106: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
2107: l_requestor per_people_f.FULL_NAME%TYPE;
2108: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
2109: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
2110: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
2111:
2112: -- END of Bug fix for 3916663
2105: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
2106: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
2107: l_requestor per_people_f.FULL_NAME%TYPE;
2108: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
2109: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
2110: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
2111:
2112: -- END of Bug fix for 3916663
2113: l_routing_name VARCHAR2(30);