DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on HR_LOCATIONS

Line 374: , hr_locations_all hrl1

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

Line 375: , hr_locations_all hrl2

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

Line 456: , hr_locations_all hrl1

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

Line 457: , hr_locations_all hrl2

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

Line 556: , hr_locations hrl1

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

Line 557: , hr_locations hrl2

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

Line 717: , hr_locations_all hrl1

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

Line 718: , hr_locations_all hrl2

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

Line 915: , hr_locations_all hrl1

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

Line 916: , hr_locations_all hrl2

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

Line 1098: , hr_locations_all hrl1

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

Line 1099: , hr_locations_all hrl2

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

Line 2108: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;

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

Line 2109: l_location_code hr_locations_all.LOCATION_CODE%TYPE;

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);