APPS.WMS_PARAMETER_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 5071: FROM wms_license_plate_numbers wlpn1

5067: SELECT SUM(moqdx.primary_transaction_quantity)
5068: INTO l_return_value
5069: FROM mtl_onhand_quantities_detail moqdx
5070: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5071: FROM wms_license_plate_numbers wlpn1
5072: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5073: AND moqdx.inventory_item_id = p_inventory_item_id
5074: AND NVL(moqdx.revision, '-99') = NVL(p_revision, '-99')
5075: AND NVL(moqdx.lot_number, '-9999') = NVL(p_lot_number, '-9999');

Line 5100: FROM wms_license_plate_numbers wlpn1

5096: SELECT SUM(moqdx.primary_transaction_quantity)
5097: INTO l_return_value
5098: FROM mtl_onhand_quantities_detail moqdx
5099: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5100: FROM wms_license_plate_numbers wlpn1
5101: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5102: AND moqdx.inventory_item_id = p_inventory_item_id;
5103:
5104: RETURN l_return_value;

Line 5126: FROM wms_license_plate_numbers wlpn1

5122: SELECT COUNT(DISTINCT (moqdx.inventory_item_id)) - 1
5123: INTO l_return_value
5124: FROM mtl_onhand_quantities_detail moqdx
5125: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5126: FROM wms_license_plate_numbers wlpn1
5127: WHERE wlpn1.outermost_lpn_id = p_lpn_id);
5128:
5129: RETURN l_return_value;
5130: EXCEPTION

Line 5152: FROM wms_license_plate_numbers wlpn1

5148: SELECT COUNT(DISTINCT (moqdx.revision)) - 1
5149: INTO l_return_value
5150: FROM mtl_onhand_quantities_detail moqdx
5151: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5152: FROM wms_license_plate_numbers wlpn1
5153: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5154: AND moqdx.inventory_item_id = p_inventory_item_id;
5155:
5156: RETURN l_return_value;

Line 5179: FROM wms_license_plate_numbers wlpn1

5175: SELECT COUNT(DISTINCT (moqdx.lot_number)) - 1
5176: INTO l_return_value
5177: FROM mtl_onhand_quantities_detail moqdx
5178: WHERE moqdx.lpn_id IN (SELECT wlpn1.lpn_id
5179: FROM wms_license_plate_numbers wlpn1
5180: WHERE wlpn1.outermost_lpn_id = p_lpn_id)
5181: AND moqdx.inventory_item_id = p_inventory_item_id;
5182:
5183: RETURN l_return_value;

Line 5329: FROM wms_license_plate_numbers wlpnx

5325: END IF;
5326:
5327: SELECT COUNT(wlpnx.lpn_id)
5328: INTO l_return_value
5329: FROM wms_license_plate_numbers wlpnx
5330: START WITH wlpnx.lpn_id = p_lpn_id
5331: CONNECT BY wlpnx.lpn_id = PRIOR parent_lpn_id;
5332:
5333: RETURN l_return_value;