eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on HR_LOCATIONS

Line 9769: hr_locations hl

9765:
9766: SELECT 'Y', line_location_id
9767: INTO l_po_shipment_is_valid_flag, l_po_line_location_id
9768: FROM po_line_locations pll,
9769: hr_locations hl
9770: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
9771: AND hl.location_id = pll.ship_to_location_id
9772: AND pll.po_header_id = l_po_header_id
9773: AND pll.po_line_id = l_po_line_id;

Line 9895: FROM po_line_locations pll, hr_locations hl

9891: SELECT 'Y', line_location_id,
9892: po_line_id
9893: INTO l_po_shipment_is_valid_flag, l_po_line_location_id,
9894: l_po_line_id
9895: FROM po_line_locations pll, hr_locations hl
9896: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
9897: AND hl.location_id = pll.ship_to_location_id
9898: AND pll.po_header_id = l_po_header_id
9899: AND pll.po_release_id = l_po_release_id;

Line 9989: hr_locations hl

9985:
9986: SELECT 'Y'
9987: INTO l_po_shipment_is_consis_flag
9988: FROM po_line_locations pll,
9989: hr_locations hl
9990: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
9991: AND hl.location_id = pll.ship_to_location_id
9992: AND line_location_id = l_po_line_location_id;
9993:

Line 10037: hr_locations hl

10033: --
10034: SELECT 'Y'
10035: INTO l_po_shipment_is_consis_flag
10036: FROM po_line_locations pll,
10037: hr_locations hl
10038: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
10039: AND hl.location_id = pll.ship_to_location_id
10040: AND po_line_id = l_po_line_id
10041: AND shipment_num = p_invoice_lines_rec.po_shipment_num

Line 10175: hr_locations hl

10171: --
10172: SELECT 'Y'
10173: INTO l_po_shipment_is_consis_flag
10174: FROM po_line_locations pll,
10175: hr_locations hl
10176: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
10177: AND hl.location_id = pll.ship_to_location_id
10178: AND po_release_id = l_po_release_id
10179: AND shipment_num = p_invoice_lines_rec.po_shipment_num

Line 21724: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is

21720: p_default_last_update_login IN NUMBER,
21721: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
21722: p_calling_sequence IN VARCHAR2) return boolean IS
21723:
21724: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
21725: Select ship_to_location_id
21726: From hr_locations
21727: Where location_code = p_ship_to_loc_code
21728: and nvl(ship_to_site_flag, 'N') = 'Y';

Line 21726: From hr_locations

21722: p_calling_sequence IN VARCHAR2) return boolean IS
21723:
21724: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
21725: Select ship_to_location_id
21726: From hr_locations
21727: Where location_code = p_ship_to_loc_code
21728: and nvl(ship_to_site_flag, 'N') = 'Y';
21729:
21730: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;