APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on HR_LOCATIONS

Line 739: req_ship_to_location_id hr_locations.ship_to_location_id%TYPE;

735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;
737: sol_uom_code VARCHAR2(10);
738: req_line_uom VARCHAR2(10);
739: req_ship_to_location_id hr_locations.ship_to_location_id%TYPE;
740: message_suffix VARCHAR2(2);
741: sol_ship_to_location_id PON_AUCTION_ITEM_PRICES_ALL.ship_to_location_id%TYPE;
742: sol_line_orig_code PON_AUCTION_ITEM_PRICES_ALL.LINE_ORIGINATION_CODE%TYPE;
743: BEGIN

Line 787: NVL((SELECT nvl(ship_to_location_id,location_id) FROM hr_locations WHERE location_id = prl.deliver_to_location_id), -1)

783: SELECT prl.line_type_id, nvl(prl.item_id, -1), nvl(prl.item_revision, -1), nvl(prl.category_id, -1)
784: , nvl(pol.ip_category_id, -1)
785: ,nvl(decode(plt.order_type_lookup_code, 'AMOUNT', '1', mom.uom_code), 'NULL')
786: ,prl.group_line_id,
787: NVL((SELECT nvl(ship_to_location_id,location_id) FROM hr_locations WHERE location_id = prl.deliver_to_location_id), -1)
788: INTO req_line_type_id, req_item_id, req_item_revision, req_category_id
789: ,req_line_ip_category_id
790: ,req_line_uom
791: ,req_group_line_id