DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on HR_LOCATIONS

Line 710: FROM hr_locations hl, rcv_shipment_lines rsl

706: AND subinventory_type = 2
707: AND msub.secondary_inventory_name LIKE (p_sub)
708: AND ((location_id = p_location_id) OR (location_id IN (SELECT distinct(hl.location_id)
709: -- into x_location_code
710: FROM hr_locations hl, rcv_shipment_lines rsl
711: WHERE hl.location_id = nvl(rsl.deliver_to_location_id,rsl.ship_to_location_id)--bug10349270 for ASN receipt,we should get the default location against RSL.ship_to_location
712: AND rsl.shipment_header_id = p_shipment_header_id
713: AND rsl.item_id = NVL(p_item_id, rsl.item_id)
714: AND rsl.to_organization_id = p_organization_id