DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on HR_LOCATIONS

Line 367: , hr_locations_all hrl1

363: , po_headers_all pha
364: , rcv_shipment_headers rsh
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

Line 368: , hr_locations_all hrl2

364: , rcv_shipment_headers rsh
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

Line 449: , hr_locations_all hrl1

445: , po_headers_all pha
446: , rcv_shipment_headers rsh
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

Line 450: , hr_locations_all hrl2

446: , rcv_shipment_headers rsh
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

Line 549: , hr_locations hrl1

545: , po_headers_all pha
546: , rcv_shipment_headers rsh
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

Line 550: , hr_locations hrl2

546: , rcv_shipment_headers rsh
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

Line 704: , hr_locations_all hrl1

700: , po_headers_all pha
701: , rcv_shipment_headers rsh
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

Line 705: , hr_locations_all hrl2

701: , rcv_shipment_headers rsh
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

Line 890: , hr_locations_all hrl1

886: , po_headers_all pha
887: , rcv_shipment_headers rsh
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

Line 891: , hr_locations_all hrl2

887: , rcv_shipment_headers rsh
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

Line 1061: , hr_locations_all hrl1

1057: , po_headers_all pha
1058: , rcv_shipment_headers rsh
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

Line 1062: , hr_locations_all hrl2

1058: , rcv_shipment_headers rsh
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

Line 1986: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;

1982: -- Increased this variable size to the corresponding column size in the table.
1983: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1984: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1985: l_requestor per_people_f.FULL_NAME%TYPE;
1986: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1987: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1988: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1989:
1990: -- END of Bug fix for 3916663

Line 1987: l_location_code hr_locations_all.LOCATION_CODE%TYPE;

1983: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1984: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1985: l_requestor per_people_f.FULL_NAME%TYPE;
1986: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1987: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1988: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1989:
1990: -- END of Bug fix for 3916663
1991: l_routing_name VARCHAR2(30);